Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-5214

Make DATETIME arithmetic functions easier to use

    XMLWordPrintableJSON

    Details

    • Urgency:
      Low

      Description

      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.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              lukas.eder Lukas Eder
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: