db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kim Haase (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
Date Tue, 13 Feb 2007 21:36:05 GMT

    [ https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12472875
] 

Kim Haase commented on DERBY-908:
---------------------------------

Would it make sense at this point to --

1) Give the examples an "Example" header?

2) Indent the second line (WHERE clause) of the two-line examples, or put the clause on the
same line as SELECT?


> 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, docChanges_v3.diff, rrefdayfunc.html,
rrefdayfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefminutefunc.html, rrefminutefunc.html,
rrefmonthfunc.html, rrefmonthfunc.html, rrefsecondfunc.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.


Mime
View raw message