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

Support parse of ISOWEEK on BigQuery library

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.34.0, 1.35.0, 1.36.0
    • None
    • core
    • None

    Description

      Add support to:

      PARSE_DATE('%G-%V-%a', '2022-52-Sun')

      that results in

      2023-01-01

      Currently, the FormatElementEnum.IW  doesn't handle the parsing, because to do so it needs to set the calendar in the DateFormat class to a ISO8601 calendar, but the current design only allows it to specify the pattern.

      Attachments

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-6226 Wrong ISOWEEK and no ISOYEAR on BigQuery FORMAT_DATE

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Unassigned Unassigned
              rrueda Rodrigo Rueda
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: