Zhenghua Gao created CALCITE-3528:
-------------------------------------

             Summary: TIMESTAMPADD/TIMESTAMPDIFF can't handle unit of 
MILLISECOND
                 Key: CALCITE-3528
                 URL: https://issues.apache.org/jira/browse/CALCITE-3528
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.21.0
            Reporter: Zhenghua Gao


Calcite's SQL parser can't handle unit of MILLISECOND for 
TIMESTAMPADD/TIMESTAMPDIFF functions. And I checked MySql[1], which can't 
handle unit of MILLISECOND too. 

Is there any reason to not support unit of MILLISECOND of the two function?

 [1] 
[https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_timestampadd]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to