[jira] [Created] (FLINK-19200) UNIX_TIMESTAMP function support return in millisecond

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (FLINK-19200) UNIX_TIMESTAMP function support return in millisecond

Shang Yuanchun (Jira)
leslieyuan created FLINK-19200:
----------------------------------

             Summary: 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


Now i use Flink1.10.0, i found that:

time = "2020-09-11 13:14:29.153"

UNIX_TIMESTAMP(sj)  return 1599801269

UNIX_TIMESTAMP(sj, '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)