Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-5508

Add constructor functions for DATE, TIME, TIMESTAMP, DATETIME

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.34.0
    • None
    • None

    Description

      Add "constructor" functions for DATE, TIME, TIMESTAMP, DATETIME. These are functions such as DATE(1969, 7, 20) that create date-time types and we informally call them "constructors".

      The functions are based on those in BigQuery, and would be enabled in the BigQuery library. Their names follow the terminology of BigQuery's type system, which is confusing when working in Calcite's type system. For example:

      • The function call DATETIME(1969, 7, 20, 16, 17, 40) returns a Calcite TIMESTAMP, a type that is called DATETIME in BigQuery. (Eagle landed at 4.17pm Houston time.)
      • Similarly, TIMESTAMP(DATE '1969-07-21', TIME '22:17:40') returns a Calcite TIMESTAMP WITH LOCAL TIME ZONE representing the same instant in UTC. That type is called TIMESTAMP in BigQuery.

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-5164 Planner#parser can't parse TIMESTAMP() function

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          is related to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-5446 Support TIMESTAMP WITH LOCAL TIME ZONE type in JDBC driver

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-5424 Customize handling of literals based on type system

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-5498 BigQuery TIMESTAMP() function short notation for timezone offsets isn’t supported in Java 8

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-5496 Support time zones when parsing TIMESTAMP WITH LOCAL TIME ZONE

          • Major - Major loss of function.
          • Open
          links to

          Web Link GitHub Pull Request #3521

          Activity

            People

              julianhyde Julian Hyde
              julianhyde Julian Hyde
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: