Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <3848149.1171405086168.JavaMail.jira@brutus>
Date: Tue, 13 Feb 2007 14:18:06 -0800 (PST)
From: "Kim Haase (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-908) YEAR,SECOND,MONTH, MINUTE, HOUR and
 DAY functions have incorrect information on durations.
In-Reply-To: <966197233.1138766739243.JavaMail.jira@ajax.apache.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

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

Thanks, Bryan! Yes, those look good. There are a couple of small glitches -- I don't know if they matter that much.

rrefminutefunc has a space indent at the beginning of the example, unlike the others.

In rrefsecondfunc, the syntax and example are not in bold, unlike those in the other files. 

This sort of thing could probably go on forever, though. Feel free to stop if you want!

> 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, docChanges_v4.diff, rrefdayfunc.html, rrefdayfunc.html, rrefdayfunc.html, rrefhourfunc.html, rrefhourfunc.html, rrefhourfunc.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.