You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@flink.apache.org by "Caizhi Weng (Jira)" <ji...@apache.org> on 2021/07/16 03:42:00 UTC

[jira] [Commented] (FLINK-23404) function UNIX_TIMESTAMP's result incorrect when format is 'EEE MMM dd HH:mm:ss z yyyy'

    [ 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)