Details

    • Type: Technical task
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Temporal Types
    • Labels:
      None

      Description

      Currently INTERVAL literals can appear in context of the DATE_ADD function and the operator +.
      For example:

      SELECT DATE_ADD(OrderDate,INTERVAL 30 DAY) AS OrderPayDate FROM Orders
      SELECT OrderDate + INTERVAL 30 DAY AS OrderParDate FROM Orders;
      SELECT INTERVAL 30 DAY + OrderDate AS OrderParDate FROM Orders;
      

      We will change INTERVAL from a DATE_ADD and + specific syntax to a full-functional data type, so intervals can appear in all context where a regular data type can, including:

      • INTERVAL table fields
      • INTERVAL stored routine variables, parameters, function return values
      • Hybrid built-in functions and operators, such as COALESCE, IF, CASE, LEAST, GREATEST.
      • MIN and MAX aggregate functions

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                bar Alexander Barkov
                Reporter:
                bar Alexander Barkov
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: