db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aron Rodrigues (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6332) Support SQL92 Interval on 10.9.1 (ships with glassfish)
Date Thu, 05 Sep 2013 20:23:52 GMT

    [ 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

Mime
View raw message