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] [Created] (DERBY-6332) Support SQL92 Interval on 10.9.1 (ships with glassfish)
Date Wed, 04 Sep 2013 14:59:51 GMT
Aron Rodrigues created DERBY-6332:
-------------------------------------

             Summary: 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: Task
          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