Summary

When using “TZH:TZM” format pattern in datetime-related functions, the user will see the following exception:

Can't lex input …TZH:TZM, can't find a matching pattern in TZH:TZM

Functions that are susceptible to this bug:

TO_TIME

TO_DATE

TO_TIMESTAMP

IS_TIME

IS_TIMESTAMP

UNIT_TIMESTAMP

This problem arises only when the “TZH:TZM” format is present

Relevant Versions, Tools, and Integrations

Dremio Cloud

Workaround

“TZO” can be used instead of “TZH:TZM” (“TZH:TZM” is one of the formats that “TZO” supports)