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

Fix missing/broken BigQuery date-time format elements

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • None
    • 1.37.0
    • None

    Description

      Calcite has theĀ FormatModels class which is missing support for or has incorrect implementation for the following DATE-TIME format elements:

      • YYY / Y - last three or 1 digits of year
      • MONTH formats to "Jan" instead of "JANUARY"
      • SSSSS - seconds of the day (5 digits), only SS is available that gives seconds of the minute.
      • FFn (n=1/2) - always returns seconds with precision 3 (=FF3); also BQ supports n=1-9, calcite format models supports n=1-6, should we expand this range?
      • AM/PM - Meridian formats not available

      Attachments

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            jerin_john Jerin John
            jerin_john Jerin John
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment