[
https://issues.apache.org/jira/browse/DERBY-908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12472383
]
Laura Stewart commented on DERBY-908:
-------------------------------------
There is a sentence in each of these functions which repeats some of the text
in another sentence. This duplicat text should be removed.
ORIGINAL TEXT
The DAY function returns the day part of a value.
The argument must be a date, timestamp, or a valid character string
representation of a date or timestamp that is not a CLOB, LONG VARCHAR, or XML
value. The result of the function is a large integer. If the argument can be
null, the result can be null; if the argument is null, the result is the null
value. If the argument is a date, timestamp, or valid string representation of
a date or timestamp, the result is the day part of the value, which is an
integer between 1 and 31.
PROPOSED REWORDING
The DAY function returns the day part of a value.
The argument must be a date, timestamp, or a valid character string
representation of a date or timestamp that is not a CLOB, LONG VARCHAR, or XML
value. The result of this function is a integer between 1 and 31. If the
argument can be null, the result can be null. If the argument is null, the
result is the null value.
> 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, rrefdayfunc.html, rrefhourfunc.html,
> rrefminutefunc.html, rrefmonthfunc.html, rrefsecondfunc.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.
