[jira] [Comment Edited] (FLINK-16143) Turn on more date time functions of blink planner

["Zili Chen (Jira)" <ji...@apache.org>]

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

Zili Chen edited comment on FLINK-16143 at 2/19/20 11:17 AM:
-------------------------------------------------------------

[~docete] Another problem is what does it produce

{{timestampdiff(DAY, 1, date '2016-06-15 00:01:02')}}

?

I think DATESUB gives only date part but not sure what behavior timestamp diff obeys.


was (Author: tison):
[~docete] Another problem is what does it produce

{{timestampdiff(DAY, 1, date '2016-06-15 00:01:02')}}

?

I think DATE_DIFF gives only date part but not sure what behavior timestamp diff obeys.

> 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)