[
https://issues.apache.org/jira/browse/CALCITE-3013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16836135#comment-16836135
]
Julian Hyde commented on CALCITE-3013:
--------------------------------------
I guess you think that {{ceil(0 to day)}} should return {{DATE '1970-01-01'}}
or {{TIMESTAMP '1970-01-01 00:00:00'}}. (Please correct me if I'm wrong.) But
the problem with that is that it makes 1970-01-01 a special date. It is special
in Unix, and in Java, but not in SQL. SQL has no special dates. There is no
"zero" in that number line.
> support CeilFuncBigInt <BIGINT> TO <TIME_UNIT>
> ----------------------------------------------
>
> Key: CALCITE-3013
> URL: https://issues.apache.org/jira/browse/CALCITE-3013
> Project: Calcite
> Issue Type: Test
> Reporter: xzh_dz
> Priority: Trivial
> Labels: pull-request-available
> Time Spent: 10m
> Remaining Estimate: 0h
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
