Make DATETIME arithmetic functions easier to use
------------------------------------------------
Key: DERBY-5214
URL: https://issues.apache.org/jira/browse/DERBY-5214
Project: Derby
Issue Type: Improvement
Components: JDBC, SQL
Affects Versions: 10.8.1.2
Reporter: Lukas Eder
Priority: Minor
Quite a few functions are supported in Derby's proprietary "JDBC escape syntax":
http://db.apache.org/derby/docs/10.8/ref/rrefjdbc88908.html
Most of those functions can also be used without that syntax, e.g.
SELECT {fn abs(FIELD)}, abs(FIELD) FROM TABLE
will return two times the same value.
This doesn't hold true for TIMESTAMPADD and TIMESTAMPDIFF, which are not
available in the "regular" syntax according to:
http://db.apache.org/derby/docs/10.8/ref/rrefsqlj29026.html
It would probably be a lot simpler for most users, not to get used to the {fn
...} syntax.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
