[
https://issues.apache.org/jira/browse/FLINK-25304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17459161#comment-17459161
]
Marios Trivyzas commented on FLINK-25304:
-----------------------------------------
> We also pad DECIMAL digits, right?
Yep, we do, respecting the *scale* of the type (decimal digits).
> TIMESTAMP/TIMESTAMP_LTZ Pad with trailing zeros for fractional seconds
> depending on the precision specified
> -----------------------------------------------------------------------------------------------------------
>
> Key: FLINK-25304
> URL: https://issues.apache.org/jira/browse/FLINK-25304
> Project: Flink
> Issue Type: Sub-task
> Reporter: Marios Trivyzas
> Priority: Major
>
> Should we pad with trailing zeros for the fractional second part?
> e.g.:
>
> {noformat}
> CAST(CAST('2021-12-13 11:22:33.123456' AS TIMESTAMP(9) AS STRING){noformat}
> Should it return:
>
> {noformat}
> 2021-12-13 11:22:33.123456{noformat}
> or:
> {noformat}
> 2021-12-13 11:22:33.123456000{noformat}
> ?
>
>
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
