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
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 – 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
