db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
Date Sun, 25 Feb 2007 15:55:05 GMT

     [ 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.


Mime
View raw message