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 Thu, 16 Jun 2005 23:03:47 GMT
    [ http://issues.apache.org/jira/browse/DERBY-355?page=comments#action_12313876 ] 

Jack Klebanoff commented on DERBY-355:

The TIMESTAMPADD and TIMESTAMPDIFF functions should be documented in the "JDBC escape syntax
for fn keyword" section not in the higher level, "JDBC escape syntax" section.

Suresh read the document more carefully than I. He is right. The document's advice to not
use a datetime column inside a TIMESTAMPADD or TIMESTAMPDIFF function is correct but its reason
wront: it is missing a "not". It might be helpful if we included my example of what not to
do and how to fix it in the Derby document.

> -------------------------------------------------
>          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:
>  Attachments: derby355finaldraft3.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:
For more information on JIRA, see:

View raw message