[ https://issues.apache.org/jira/browse/FLINK-19200?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17198099#comment-17198099 ]
leslieyuan commented on FLINK-19200: ------------------------------------ [~jark] Hi jark thanks for your work, in my opinion, way(2) sound good to me. > 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)