Ramin Gharib created FLINK-39244:
------------------------------------
Summary: Support precision 0-9 for TO_TIMESTAMP_LTZ function
Key: FLINK-39244
URL: https://issues.apache.org/jira/browse/FLINK-39244
Project: Flink
Issue Type: Improvement
Components: Table SQL / API
Reporter: Ramin Gharib
Currently, TO_TIMESTAMP_LTZ(numeric, precision) only supports precision values
of 0 (seconds) and 3 (milliseconds). This limits users who need to work with
higher-precision epoch values such as microseconds or nanoseconds.
This change extends TO_TIMESTAMP_LTZ to support all precision values from 0 to
9, where the precision parameter specifies the unit of the epoch value as
10^(-precision) seconds:
- 0 = seconds
- 3 = milliseconds
- 6 = microseconds
- 9 = nanoseconds
- Other values (1, 2, 4, 5, 7, 8) are also supported
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
