You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "James Mcguire (Jira)" <ji...@apache.org> on 2023/03/03 19:43:00 UTC
[jira] [Created] (FLINK-31320) Modify DATE_FORMAT system (built-in) function to accepts DATEs
James Mcguire created FLINK-31320:
-------------------------------------
Summary: Modify DATE_FORMAT system (built-in) function to accepts DATEs
Key: FLINK-31320
URL: https://issues.apache.org/jira/browse/FLINK-31320
Project: Flink
Issue Type: Improvement
Components: Table SQL / API
Reporter: James Mcguire
The current {{DATE_FORMAT}} function only supports {{{}TIMESTAMP{}}}s.
(See https://nightlies.apache.org/flink/flink-docs-master/docs/dev/table/functions/systemfunctions/#temporal-functions)
Ideally, it should be able to format {{{}DATE{}}}'s as well as {{TIMESTAMPs}}
Example usage:
{noformat}
Flink SQL> CREATE TABLE test_table (
> some_date DATE,
> object AS JSON_OBJECT(
> KEY 'some_date' VALUE DATE_FORMAT(some_date, 'YYYY-MM-dd')
> )
> )
> COMMENT ''
> WITH (
> 'connector'='datagen'
> )
> ;
>
[ERROR] Could not execute SQL statement. Reason:
org.apache.calcite.sql.validate.SqlValidatorException: Cannot apply 'DATE_FORMAT' to arguments of type 'DATE_FORMAT(<DATE>, <CHAR(10)>)'. Supported form(s): 'DATE_FORMAT(<TIMESTAMP>, <STRING>)'
'DATE_FORMAT(<STRING>, <STRING>)'{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)