[
https://issues.apache.org/jira/browse/DERBY-6332?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13759406#comment-13759406
]
Aron Rodrigues commented on DERBY-6332:
---------------------------------------
Thank you but I already saw it.
My request is to derby supports SQL92 Interval, so the same script could run on
Oracle, MySQL, SQLServer and Derby. Even in the clients.
> 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
