[
https://issues.apache.org/jira/browse/FLINK-31824?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713525#comment-17713525
]
Ran Tao commented on FLINK-31824:
---------------------------------
[~leishuiyu]
1.The date pattern with T need double-quoted such as
"yyyy-MM-dd'T'HH:mm:ss.SSS", while Z is no need to do this.
why u try to match a 'Z' placeholder but without date zone content?
I think the common usage could be like:
{code:java}
Flink SQL> select TO_TIMESTAMP('2022-04-18T12:34:56.000+0800',
'yyyy-MM-dd''T''HH:mm:ss.SSSZ'); {code}
> flink sql TO_TIMESTAMP error
> ----------------------------
>
> Key: FLINK-31824
> URL: https://issues.apache.org/jira/browse/FLINK-31824
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / Planner
> Affects Versions: 1.14.3
> Environment: the verion is 1.14.3
> Reporter: leishuiyu
> Priority: Major
> Attachments: image-2023-04-17-20-07-17-569.png
>
>
>
>
>
>
>
>
> !image-2023-04-17-20-07-17-569.png!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
