Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-62042

STR_TO_TZ() output missing TZ minutes with 'Z' as the input TZ.

    XMLWordPrintable

Details

    • Untriaged
    • 0
    • Yes

    Description

      When the input to STR_TO_TZ has 'Z' as the time zone, the output uses an hour-only format.

      e.g. STR_TO_TZ("2024-01-01T00:00:00Z", "America/Los_Angeles") -> "2023-12-31T16:00:00-08"

      In version 6 and version 7.6+ the output is "2023-12-31T16:00:00-08:00".

      This affects comparisons as the strings differ.

      Attachments

        Issue Links

          relates to

          Improvement - An improvement or enhancement to an existing feature or task. MB-47082 Support additional date format specifications for parsing and writing strings.

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

          Improvement - An improvement or enhancement to an existing feature or task. MB-50528 Improve performance of date format determination

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

          Activity

            People

              pierre.regazzoni Pierre Regazzoni
              Donald.haggart Donald Haggart
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                PagerDuty