[
https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Bryan Pendleton updated DERBY-908:
----------------------------------
Attachment: rrefminutefunc.html
minuteExample.diff
It occurs to me that the "classes" example was meant to refer to an academic
calendar example. For example the class schedule for the school might indicate
that the first class period of the day started at 8:10 AM and ended at 9:05 AM.
So the use of "classes" rather than "rows" was probably intentional.
But I think the "flights" example is good too, and if it is clearer to readers,
that's better.
Attached is minuteExample.diff, and rrefminutefunc.html. This patch changes the
example on the MINUTE page of the reference manual to correct the error of the
previous example, which was that the result of the function is *always* less
than 60, since the function's values range from 0 to 59.
Please let me know if you think the new example is clear.
> 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
> Fix For: 10.3.0.0
>
> Attachments: docChanges.diff, docChanges_v2.diff, docChanges_v3.diff,
> docChanges_v4.diff, minuteExample.diff, rrefdayfunc.html, rrefdayfunc.html,
> rrefdayfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefhourfunc.html,
> rrefminutefunc.html, rrefminutefunc.html, rrefminutefunc.html,
> rrefminutefunc.html, rrefmonthfunc.html, rrefmonthfunc.html,
> rrefmonthfunc.html, rrefsecondfunc.html, rrefsecondfunc.html,
> rrefsecondfunc.html, rrefsecondfunc.html, rrefyearfunc.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.
