[jira] [Commented] (CALCITE-1827) Add DATEADD as build-in scalar function

["sunjincheng (JIRA)" <ji...@apache.org>]

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

sunjincheng commented on CALCITE-1827:
--------------------------------------

Hi, [~julianhyde], If i not missing something, currently {{DATEADD}}  is not supported by calcite. So I want add {{DATEADD}} as build-in scalar function. What do you think?


> Add DATEADD as build-in scalar function
> ---------------------------------------
>
>                 Key: CALCITE-1827
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1827
>             Project: Calcite
>          Issue Type: New Feature
>          Components: core
>            Reporter: sunjincheng
>            Assignee: sunjincheng
>
> Syntax
> DATEADD (datepart , number , date ) 
> -datepart
> Is the part of date to which an integer number is added. 
> -number
> Is an expression that can be resolved to an int that is added to a datepart of date
> -date
> Is an expression that can be resolved to a time.
> Example
> SELECT DATEADD(month, 1, '2017-05-31') from tab; --> 2017-06-30 00:00:00.000
> MSSQL:
> https://docs.microsoft.com/en-us/sql/t-sql/functions/dateadd-transact-sql
> MySql:
> https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html#function_date-add



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)