[
https://issues.apache.org/jira/browse/FLINK-23404?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17381710#comment-17381710
]
Caizhi Weng commented on FLINK-23404:
-------------------------------------
[~alfred.zou] day name in week depends on your locale. You can set your locale
to US by {{Locale.setDefault(Locale.US)}} and run this SQL again. This should
work.
For a side note: when parsing fails, {{UNIX_TIMESTAMP}} returns
{{Long.MIN_VALUE}}.
> function UNIX_TIMESTAMP's result incorrect when format is 'EEE MMM dd
> HH:mm:ss z yyyy'
> --------------------------------------------------------------------------------------
>
> Key: FLINK-23404
> URL: https://issues.apache.org/jira/browse/FLINK-23404
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / Planner, Table SQL / Runtime
> Affects Versions: 1.12.2, 1.14.0
> Reporter: alfred.zou
> Priority: Major
>
> blink planner, eg: UNIX_TIMESTAMP('Thu Jul 15 17:34:35 CST 2021', 'EEE MMM dd
> HH:mm:ss z yyyy
> )'s result is -9223372036854775808, which is incorrect.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
