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: 10.8.2.2
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:
http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt
This seems not to be supported directly by Derby. Instead, Derby supports
functions for constructing DATE, TIME, TIMESTAMP values. For example:
http://db.apache.org/derby/docs/dev/ref/rreftimestampfunc.html
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
