[ https://issues.apache.org/jira/browse/FLINK-19200?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17632108#comment-17632108 ]
Xuannan Su commented on FLINK-19200: ------------------------------------ Any update on this issue? I am also looking for a way to convert timestamp to millisecond epoch. > 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 / API > Affects Versions: 1.10.0 > Reporter: leslieyuan > Priority: Not a Priority > Labels: auto-deprioritized-major, auto-deprioritized-minor > > 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.20.10#820010)