[ 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. > 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: 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: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
