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 21:33:06 GMT

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

Laura Stewart commented on DERBY-908:

Bryan - These updates look really good.  One minor thing, if you have time to fix it...

In the  Seconds function (rrefsecondfunc.html) Example.  I think it should be reworded to:

The RECEIVED column contains a timestamp that has an internal value equivalent to 2005-12-25-
To return only the seconds part of the timestamp, use the following syntax:

If you can't make this change, let me know and I'll add a new JIRA issue for this.

> 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:
>            Reporter: Daniel John Debrunner
>         Assigned To: Bryan Pendleton
>            Priority: Minor
>         Attachments: docChanges.diff, docChanges_v2.diff, rrefdayfunc.html, rrefdayfunc.html,
rrefhourfunc.html, rrefhourfunc.html, rrefminutefunc.html, rrefminutefunc.html, rrefmonthfunc.html,
rrefmonthfunc.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.

View raw message