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 "Myrna van Lunteren (JIRA)" <ji...@apache.org> on 2013/09/04 22:59:52 UTC
[jira] [Updated] (DERBY-6332) Support SQL92 Interval on 10.9.1
(ships with glassfish)
[ https://issues.apache.org/jira/browse/DERBY-6332?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Myrna van Lunteren updated DERBY-6332:
--------------------------------------
Issue Type: Improvement (was: Task)
> Support SQL92 Interval on 10.9.1 (ships with glassfish)
> -------------------------------------------------------
>
> Key: DERBY-6332
> URL: https://issues.apache.org/jira/browse/DERBY-6332
> Project: Derby
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 10.9.1.0
> Environment: javadb shipped with glassfish
> Reporter: Aron Rodrigues
>
> I can't run sql92 queries like
> create table c (c datetime);
> insert into c values(CURRENT_TIMESTAMP - INTERVAL 2 DAY);
> insert into c values(CURRENT_TIMESTAMP - INTERVAL '1' DAY);
> insert into c values(CURRENT_TIMESTAMP - INTERVAL '1' HOUR);
> insert into c values(CURRENT_TIMESTAMP-INTERVAL '-1' DAY);
> select * from c;
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira