Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • None
    • None
    • None
    • None

    Description

      Add support for BigQuery's TIME() function. The function constructs a TIME expression from the provided arguments.

      There are three ways the function can be called:
      1. TIME(HOUR, MINUTE, SECOND)
      2. TIME(TIMESTAMP [, TIMEZONE]) (Calcite does not currently support timestamp with time zone.
      3. TIME(DATETIME) (Calcite does not currently support DATETIME)

      Examples:
      TIME(5, 30, 50) would return '05:30:50'.
      TIME(TIMESTAMP '2008-12-25 15:30:00') would return '15:30:00'.

      BigQuery Docs

      Attachments

        Activity

          People

            tanclary Tanner Clary
            tanclary Tanner Clary
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: