[jira] [Commented] (CALCITE-1606) Add missing support for datetime JDBC functions

["Laurent Goujon (JIRA)" <ji...@apache.org>]

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

Laurent Goujon commented on CALCITE-1606:
-----------------------------------------

Proposed patch: https://github.com/apache/calcite/pull/364

> Add missing support for datetime JDBC functions
> -----------------------------------------------
>
>                 Key: CALCITE-1606
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1606
>             Project: Calcite
>          Issue Type: Improvement
>          Components: core
>            Reporter: Laurent Goujon
>            Assignee: Julian Hyde
>            Priority: Minor
>
> Calcite advertises support for all datetime functions but implementations are missing for some of them.
> Since Calcite already supports EXTRACT(timeUnit FROM datetime), support could be added for the following functions: YEAR, MONTH, WEEK, DAYOFYEAR, DAYOFMONTH, DAYOFWEEK, HOUR, MINUTE, SECOND.
> Some concrete implementation (like WEEK) would be missing, but if RexImpTable is updated to support it, then it would be fully wired.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)