db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Laura Stewart (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.
Date Mon, 12 Feb 2007 18:43:06 GMT

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


Mime
View raw message