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] Assigned: (DERBY-81) Datetime datatypes should allow arithmetic operations on them.
Date Tue, 24 May 2005 02:36:53 GMT
     [ http://issues.apache.org/jira/browse/DERBY-81?page=all ]

Satheesh Bandaram reassigned DERBY-81:

    Assign To: Jack Klebanoff  (was: Satheesh Bandaram)

Please update the bug description according to your proposal.

> Datetime datatypes should allow arithmetic operations on them.
> --------------------------------------------------------------
>          Key: DERBY-81
>          URL: http://issues.apache.org/jira/browse/DERBY-81
>      Project: Derby
>         Type: New Feature
>   Components: SQL
>     Versions:
>  Environment: Generic
>     Reporter: Satheesh Bandaram
>     Assignee: Jack Klebanoff

> 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
>    SELECT * FROM log 
>    WHERE modified_time > CURRENT_TIMESTAMP - 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:
For more information on JIRA, see:

View raw message