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

Wrong ISOWEEK and no ISOYEAR on BigQuery FORMAT_DATE

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.34.0, 1.35.0, 1.36.0
    • 1.38.0
    • core

    Description

       

      Doing:

      FORMAT_DATE('%G-%V', DATE '2023-01-01')

       results in:

      '%G-01'

      but should be:

      2022-52

       

      The week is wrong because the ISOWEEK format function is not setting the minimalDaysInFirstWeek to 4 and the ISOYEAR (%g or %G) was not implemented.

      Attachments

        Issue Links

          blocks

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-6582 Release Calcite 1.38.0

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

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-6233 Support parse of ISOWEEK on BigQuery library

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

          Web Link GitHub Pull Request #3653

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: