[
https://issues.apache.org/jira/browse/FLINK-19200?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17201280#comment-17201280
]
Jingsong Lee commented on FLINK-19200:
--------------------------------------
3) Use date_diff [3] with interval. Eg: {{DATEDIFF(MILLISECOND, 0,
'00:00:23.323')}}
[3]https://www.w3schools.com/sql/func_sqlserver_datediff.asp
> 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)
