[
https://issues.apache.org/jira/browse/FLINK-19200?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17201279#comment-17201279
]
Jark Wu commented on FLINK-19200:
---------------------------------
[~lzljs3620320] we can infer that from the format literal.
> UNIX_TIMESTAMP function support return in millisecond
> -----------------------------------------------------
>
> Key: FLINK-19200
> URL: https://issues.apache.org/jira/browse/FLINK-19200
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / Planner
> Affects Versions: 1.10.0
> Reporter: leslieyuan
> Priority: Major
>
> Now i use Flink1.10.0, i found that:
> time = "2020-09-11 13:14:29.153"
> UNIX_TIMESTAMP(time) return 1599801269
> UNIX_TIMESTAMP(time, 'yyyy-MM-dd HH:mm:ss.SSS') also return 1599801269
> Yes, i see the Official website description, this function return in seconds,
> but i think if i had given the format as above, which means that i need the
> millisecond.
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
