[ 
https://issues.apache.org/jira/browse/CALCITE-1662?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15886277#comment-15886277
 ] 

Remus Rusanu commented on CALCITE-1662:
---------------------------------------

Well, MySQL {{select TIMESTAMP '2016-02-26 19:00:00.789' - TIMESTAMP 
'2016-02-26 19:00:00.123'}} is definetely something else that what I believed 
it is. The correct form {{select TIMESTAMP('2016-02-26 19:00:00.789') - 
TIMESTAMP('2016-02-26 19:00:00.123')}} returns the difference (in MySQL).

> TimestampDiffConvertlet uses second resolution even for sub-second units
> ------------------------------------------------------------------------
>
>                 Key: CALCITE-1662
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1662
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Remus Rusanu
>            Assignee: Julian Hyde
>
> {{TimestampDiffConvertlet.convertCall}} uses {{TimeUnit.SECOND}} for 
> sub-second units. 



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Reply via email to