[
https://issues.apache.org/jira/browse/CALCITE-3013?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde reopened CALCITE-3013:
----------------------------------
Now I see there is a PR for this. I guess not everyone considers this closed,
so let's re-open for discussion.
I don't see a need for this function. The SQL standard tries hard to maintain
the abstraction that datetime values are NOT just milliseconds since 1970 (and
it succeeds). For instance, you can write {{(ts - TIMESTAMP '1970-01-01
00:00:00') MILLISECOND}} to convert to a millisecond interval.
If you want to add a user-defined function you can do it. It you do it right it
will probably optimize to a few machine instructions.
> 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)
