db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lukas Eder (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-5837) Add support for SQL standard DATE, TIME, TIMESTAMP literals
Date Sat, 30 Jun 2012 09:42:42 GMT
Lukas Eder created DERBY-5837:

             Summary: Add support for SQL standard DATE, TIME, TIMESTAMP literals
                 Key: DERBY-5837
                 URL: https://issues.apache.org/jira/browse/DERBY-5837
             Project: Derby
          Issue Type: Improvement
          Components: SQL
    Affects Versions:
            Reporter: Lukas Eder
            Priority: Minor

The SQL standard 1992 specifies <datetime literals> as such:

         <datetime literal> ::=
                <date literal>
              | <time literal>
              | <timestamp literal>

         <date literal> ::=
              DATE <date string>

         <time literal> ::=
              TIME <time string>

         <timestamp literal> ::=
              TIMESTAMP <timestamp string>

         <date string> ::=
              <quote> <date value> <quote>

         <time string> ::=
              <quote> <time value> [ <time zone interval> ] <quote>

         <timestamp string> ::=
              <quote> <date value> <space> <time value> [ <time
zone interval> ] <quote>

Taken from:

This seems not to be supported directly by Derby. Instead, Derby supports functions for constructing
DATE, TIME, TIMESTAMP values. For example:

For increased compatibility, it would be nice if literals were implemented according to the
standard. In essence, the function's parentheses could be made optional

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message