You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@ignite.apache.org by "Vladimir Steshin (Jira)" <ji...@apache.org> on 2022/05/17 14:57:00 UTC

[jira] [Commented] (IGNITE-14955) Calcite engine. Not supported DATE/TIME functions

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

Vladimir Steshin commented on IGNITE-14955:
-------------------------------------------

There are analogues like WEEK(date), EXTRACT(timeUnit FROM datetime), FLOOR(datetime TO timeUnit)
CEIL(datetime TO timeUnit). Looks like we nedd to check EXTRACT

>  Calcite engine. Not supported DATE/TIME functions
> --------------------------------------------------
>
>                 Key: IGNITE-14955
>                 URL: https://issues.apache.org/jira/browse/IGNITE-14955
>             Project: Ignite
>          Issue Type: Improvement
>            Reporter: Taras Ledkov
>            Priority: Major
>
> Not supported DATE/TIME functions operation:
> - {{YEARWEEK}};
> - {{WEEKOFYEAR}};
> - {{DATE_PART}};
> - {{DATE_PART}};
> - {{DATE_TRUNC}};
> - {{EXTRACT(microseconds FROM d)}};
> - {{EXTRACT(milliseconds FROM d)}};



--
This message was sent by Atlassian Jira
(v8.20.7#820007)