You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@flink.apache.org by "leslieyuan (Jira)" <ji...@apache.org> on 2020/09/11 06:15:00 UTC

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

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)