db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jack Klebanoff (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-355) Document TIMESTAMPADD and TIMESTAMPDIFF functions
Date Wed, 15 Jun 2005 23:14:50 GMT
    [ http://issues.apache.org/jira/browse/DERBY-355?page=comments#action_12313762 ] 

Jack Klebanoff commented on DERBY-355:
--------------------------------------

The latest patch looks good to me.

In my previous comments I agreed with the decision to put TIMESTAMPADD and TIMESTAMPDIFF in
the builtin function section. Users are more likely to find them there than in the JDBC escape
section. The other JDBC escape features have equivalent functionality in pure SQL. Users looking
through the Derby SQL reference will find the functionality and be able to get their jobs
done. I think that the JDBC escapes are a bit obscure, users looking for timestamp arithmetic
may not think of looking in the JDBC escape section.

The JDBC escape section should have at least a reference to TIMESTAMPADD and TIMESTAMPDIFF.
We can document them in the builtin function section and have references in the JDBC escape
section, or document them in the JDBC escape section and have references in the builtin function
section. I think that it is important that both sections mention the functions.

> Document TIMESTAMPADD and TIMESTAMPDIFF functions
> -------------------------------------------------
>
>          Key: DERBY-355
>          URL: http://issues.apache.org/jira/browse/DERBY-355
>      Project: Derby
>         Type: Sub-task
>   Components: Documentation
>  Environment: all
>     Reporter: Jeff Levitt
>     Assignee: Jeff Levitt
>     Priority: Minor
>      Fix For: 10.1.0.0
>  Attachments: derby355finaldraft2.zip
>
> Derby 81 (parent task to this issue) needs to be documented.  TIMESTAMPADD and TIMESTAMPDIFF
need to be included in the reference manual with the built-in functions.  I created a patch
for this which I will attach to this issue for review.  I used http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbctime__date__and_interval_functions.asp
> as my specification.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message