[ 
https://issues.apache.org/jira/browse/IGNITE-21136?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Iurii Gerzhedovich resolved IGNITE-21136.
-----------------------------------------
    Resolution: Won't Do

[~akhitrin] after implementing IGNITE-22788 we started supporting FORMAT clause 
in CAST operator which is part of SQL:2016 spec. So I'm closing the ticket 
because it is not actual anymore.

Examples of usage of the feature can be found at 
[https://github.com/apache/ignite-3/blob/main/modules/sql-engine/src/integrationTest/sql/cast/test_cast_format.test]
 

> SQL: implement functions for date/time formatting
> -------------------------------------------------
>
>                 Key: IGNITE-21136
>                 URL: https://issues.apache.org/jira/browse/IGNITE-21136
>             Project: Ignite
>          Issue Type: Improvement
>          Components: sql
>    Affects Versions: 3.0.0-beta2
>            Reporter: Andrey Khitrin
>            Assignee: Iurii Gerzhedovich
>            Priority: Major
>              Labels: ignite-3, sql
>
> SQL functions for date/time formatting are useful in many cases. In AI2, we 
> have an universal FORMATDATETIME function for such purposes:
> {code:sql}
> SELECT FORMATDATETIME(CREATION_DATE, 'yyyy-MM') AS CREATION_MONTH FROM ...
> {code}
> Please imlpement simliar functions in AI3.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to