[
https://issues.apache.org/jira/browse/FLINK-16143?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17039787#comment-17039787
]
Zhenghua Gao commented on FLINK-16143:
--------------------------------------
[~jark] Actually the TIMESTAMPDIFF/TIMESTAMPADD with DATE parameter supports
DATE type:
timestampadd(DAY, 1, date '2016-06-15') gets date '2016-06-16'
timestampdiff(DAY, date '2016-06-15', date '2016-06-14') gets -1
> Turn on more date time functions of blink planner
> -------------------------------------------------
>
> Key: FLINK-16143
> URL: https://issues.apache.org/jira/browse/FLINK-16143
> Project: Flink
> Issue Type: New Feature
> Components: Table SQL / Planner
> Reporter: Zili Chen
> Priority: Major
> Fix For: 1.11.0
>
>
> Currently blink planner has a series of built-in functions such as
> DATEDIFF
> DATE_ADD
> DATE_SUB
> which haven't been into used so far. We could add the necessary register,
> generate and convert code to make it available in production scope.
>
> what do you think [~jark]?
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
