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

BigQuery FORMAT_DATE uses the wrong calendar for Julian dates

    XMLWordPrintableJSON

Details

    Description

      For the following query:

      SELECT format_date('%A %d %B %Y', '0001-01-01')
      

      the BigQuery playground returns the following result:

      Monday 01 January 1
      

      However, Calcite returns the following result:

      Saturday 01 Jan 1
      

      There are actually two bugs here:

      • the day of the week is wrong
      • the month name is displayed incorrectly. The latter is because of the Locale.ROOT used in SimpleDateFormat.

      Attachments

        Issue Links

          Activity

            People

              mbudiu Mihai Budiu
              mbudiu Mihai Budiu
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: