[
https://issues.apache.org/jira/browse/FLINK-25304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17459156#comment-17459156
]
Timo Walther commented on FLINK-25304:
--------------------------------------
+1 for the current behavior. We also pad DECIMAL digits, right? So we do the
same with timestamps for consistency.
> 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)
