[
https://issues.apache.org/jira/browse/BEAM-10340?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17548736#comment-17548736
]
Danny McCormick commented on BEAM-10340:
----------------------------------------
This issue has been migrated to https://github.com/apache/beam/issues/20351
> Lost of precision when casting ZetaSQL time with microsecond-precision
> -----------------------------------------------------------------------
>
> Key: BEAM-10340
> URL: https://issues.apache.org/jira/browse/BEAM-10340
> Project: Beam
> Issue Type: Improvement
> Components: dsl-sql-zetasql
> Reporter: Zijie Song
> Priority: P3
>
> When we cast ZetaSQL time value with microsecond-precision to string, it
> currently would cause lost of precision.
> For example, when we parse the following SQL statement:
>
> "SELECT CAST(s1 as TIME) as t2, CAST(t1 as STRING) as s2
> FROM (SELECT '12:34:56.123456' as s1, TIME '12:34:56.123456' as t1)"
> the result would be 12:34:46, and the corresponding microsecond precision
> would lost.
>
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
