[ http://issues.apache.org/jira/browse/DERBY-81?page=all ]
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. Enable
datetime arithmetic in a standard way.
This feature has already been implemented in 10.1 and is documented in Derby
10.1 manuals. Refer to functionality there.
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://issues.apache.org/jira/browse/DERBY-81
> Project: Derby
> Type: New Feature
> Components: SQL
> Versions: 10.0.2.0
> Environment: Generic
> Reporter: Satheesh Bandaram
> Fix For: 10.1.1.0
>
> Datetime datatypes in Derby are date, time and timestamp. Currently Derby
> doesn't allow any arithmetic operations on them, limiting their use. Enable
> datetime arithmetic in a standard way.
> This feature has already been implemented in 10.1 and is documented in Derby
> 10.1 manuals. Refer to functionality there.
--
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
