You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Satheesh Bandaram (JIRA)" <de...@db.apache.org> on 2004/11/24 19:47:24 UTC
[jira] Updated: (DERBY-81) Datetime datatypes should allow arithmetic operations on them.
[ http://nagoya.apache.org/jira/browse/DERBY-81?page=history ]
Satheesh Bandaram updated DERBY-81:
-----------------------------------
Description:
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 - 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.
was:
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 – 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.
> 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
> Assignee: 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 - 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