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: <980410189.1101322042948.JavaMail.apache@nagoya>
Date: Wed, 24 Nov 2004 10:47:22 -0800 (PST)
From: "Satheesh Bandaram (JIRA)" <derby-dev@db.apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Created: (DERBY-81) Datetime datatypes should allow arithmetic
 operations on them.
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Datetime datatypes should allow arithmetic operations on them.
--------------------------------------------------------------

         Key: DERBY-81
         URL: http://nagoya.apache.org/jira/browse/DERBY-81
     Project: Derby
        Type: New Feature
  Components: SQL  
    Versions: 10.0.2.0    
 Environment: Generic
    Reporter: Satheesh Bandaram
 Assigned to: Satheesh Bandaram 


Datetime datatypes in Derby are date, time and timestamp. Currently Derby doesn't allow any arithmetic operations on them, limiting their use. It would be great to allow statements like:

   SELECT * FROM log 
   WHERE modified_time > CURRENT_TIMESTAMP &#8211; 1 MONTH

Commercial databases like Oracle, DB2 and mySQL also have this feature. SQL standard allows these operations along with INTERVAL types. Since Derby doesn't have INTERVAL datatypes, I would like to propose datetime arithmetic to Derby without INTERVALs.

It should be possible to add, subtract datetime datatypes with a constant like '1 MONTH' (called a duration or INTERVAL in SQL standard). It should also be possible to subtract datetime types where the semantics are allowed according to SQL standard specification.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://nagoya.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira