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

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

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

Julian Hyde updated CALCITE-1827:
---------------------------------
    Description: 
Syntax: {{DATEADD (datepart , number , date ) }}

Arguments:
* 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

{code}SELECT DATEADD(month, 1, '2017-05-31') from tab;{code}

returns {{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

  was:
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


> 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 ) }}
> Arguments:
> * 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
> {code}SELECT DATEADD(month, 1, '2017-05-31') from tab;{code}
> returns {{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)