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

Implement BigQuery functions for DATE, TIME, TIMESTAMP, DATETIME

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      Implement missing BigQuery functions for DATE, TIME, TIMESTAMP, DATETIME.

      Functions include:

      • CURRENT_DATE, CURRENT_DATETIME, CURRENT_TIME with timezone;
      • EXTRACT with time unit values WEEK(weekday), DATE, TIME;
      • various DATE, TIME, TIMESTAMP, DATETIME constructor functions;
      • DATE_ADD, DATETIME_ADD, TIME_ADD, TIMESTAMP_ADD;
      • DATE_SUB, DATETIME_SUB, TIME_SUB, TIMESTAMP_SUB;
      • DATE_DIFF, DATETIME_DIFF, TIME_DIFF, TIMESTAMP_DIFF;
      • DATE_TRUNC, DATETIME_TRUNC, TIME_TRUNC, TIMESTAMP_TRUNC;
      • LAST_DAY;
      • FORMAT_DATE, FORMAT_DATETIME, FORMAT_TIME, FORMAT_TIMESTAMP;
      • PARSE_DATE, PARSE_DATETIME, PARSE_TIME, PARSE_TIMESTAMP.

      The following functions are already implemented: CURRENT_DATETME, DATE(string), DATE_FROM_UNIX_DATE, TIMESTAMP_MICROS, TIMESTAMP_MILLIS, TIMESTAMP_SECONDS, UNIX_MICROS, UNIX_MILLIS, UNIX_SECONDS, UNIX_DATE.

      Attachments

        Issue Links

          is a parent of

          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

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-5447 Add DATE_TRUNC for BigQuery

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

          Wish - General wishlist item. CALCITE-5543 Implement BigQuery functions for parsing DATE, TIME, TIMESTAMP, DATETIME

          • Major - Major loss of function.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-759 Add DayOfWeek and other missing date/time functions

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-3218 Syntax error while parsing DATEADD function (which is valid on Redshift)

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-5290 Add DATE_TRUNC function consistent with Postgres

          • Major - Major loss of function.
          • In Progress
          links to

          Web Link GitHub Pull Request #2913

          Web Link GitHub Pull Request #2973

          Web Link GitHub Pull Request #3023

          Web Link GitHub Pull Request #3039

          Activity

            People

              wnoble Will Noble
              julianhyde Julian Hyde
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 21h 10m
                  21h 10m