db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Satheesh Bandaram (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-81) Datetime datatypes should allow arithmetic operations on them.
Date Wed, 24 Nov 2004 18:47:22 GMT
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  
 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:
If you want more information on JIRA, or have a bug to report see:

View raw message