Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Development" <derby-dev@db.apache.org>
Message-ID: <1573905829.1118877290488.JavaMail.jira@ajax.apache.org>
Date: Thu, 16 Jun 2005 01:14:50 +0200 (CEST)
From: "Jack Klebanoff (JIRA)" <derby-dev@db.apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-355) Document TIMESTAMPADD and TIMESTAMPDIFF
 functions
In-Reply-To: <1980281437.1118718167659.JavaMail.jira@ajax.apache.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

    [ http://issues.apache.org/jira/browse/DERBY-355?page=comments#action_12313762 ] 

Jack Klebanoff commented on DERBY-355:
--------------------------------------

The latest patch looks good to me.

In my previous comments I agreed with the decision to put TIMESTAMPADD and TIMESTAMPDIFF in the builtin function section. Users are more likely to find them there than in the JDBC escape section. The other JDBC escape features have equivalent functionality in pure SQL. Users looking through the Derby SQL reference will find the functionality and be able to get their jobs done. I think that the JDBC escapes are a bit obscure, users looking for timestamp arithmetic may not think of looking in the JDBC escape section.

The JDBC escape section should have at least a reference to TIMESTAMPADD and TIMESTAMPDIFF. We can document them in the builtin function section and have references in the JDBC escape section, or document them in the JDBC escape section and have references in the builtin function section. I think that it is important that both sections mention the functions.

> Document TIMESTAMPADD and TIMESTAMPDIFF functions
> -------------------------------------------------
>
>          Key: DERBY-355
>          URL: http://issues.apache.org/jira/browse/DERBY-355
>      Project: Derby
>         Type: Sub-task
>   Components: Documentation
>  Environment: all
>     Reporter: Jeff Levitt
>     Assignee: Jeff Levitt
>     Priority: Minor
>      Fix For: 10.1.0.0
>  Attachments: derby355finaldraft2.zip
>
> Derby 81 (parent task to this issue) needs to be documented.  TIMESTAMPADD and TIMESTAMPDIFF need to be included in the reference manual with the built-in functions.  I created a patch for this which I will attach to this issue for review.  I used http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbctime__date__and_interval_functions.asp
> as my specification.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira