[ http://issues.apache.org/jira/browse/DERBY-81?page=all ]
Mike Matrigali 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.
Assign To: (was: Jack Klebanoff)
I don't believe jack is working on this any more.
> 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: 10.0.2.0
> Environment: Generic
> Reporter: 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://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
