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-5214) Make DATETIME arithmetic functions easier to use
Date Tue, 03 May 2011 12:57:03 GMT
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

Mime
View raw message