[
https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12472424
]
Laura Stewart commented on DERBY-908:
-------------------------------------
Bryan - These updates look really good. One minor thing, if you have time to
fix it...
In the Seconds function (rrefsecondfunc.html) Example. I think it should be
reworded to:
The RECEIVED column contains a timestamp that has an internal value equivalent
to 2005-12-25-17.12.30.000000. To return only the seconds part of the
timestamp, use the following syntax:
If you can't make this change, let me know and I'll add a new JIRA issue for
this.
> YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information
> on durations.
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-908
> URL: https://issues.apache.org/jira/browse/DERBY-908
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Assigned To: Bryan Pendleton
> Priority: Minor
> Attachments: docChanges.diff, docChanges_v2.diff, rrefdayfunc.html,
> rrefdayfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefminutefunc.html,
> rrefminutefunc.html, rrefmonthfunc.html, rrefmonthfunc.html,
> rrefsecondfunc.html, rrefsecondfunc.html, rrefyearfunc.html, rrefyearfunc.html
>
>
> All these functions in the reference manual have a sentence like:
> (this is from DAY)
> If the argument is a time duration or timestamp duration: The result is the
> day part of the value, which is an integer between -99 and 99. A nonzero
> result has the same sign as the argument.
> This can be removed since Derby does not support durations. Then the
> surrounding text probably needs re-work as it leaves only a single type of
> argument.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
