[
http://issues.apache.org/jira/browse/DERBY-355?page=comments#action_12313672 ]
Jack Klebanoff commented on DERBY-355:
--------------------------------------
The real syntax of TIMESTAMPADD is
{fn TIMESTAMPADD( interval, integerExpression, timestampExpression )}
and that of TIMESTAMPDIFF is
{fn TIMESTAMPDIFF(interval, timestamp_exp1, timestamp_exp2)}
They cannot be used outside of a JDBC escape, so the documentation should
include the JDBC escape syntax in the description and examples.
> 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: derby355finaldraft.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
