You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "sunjincheng (JIRA)" <ji...@apache.org> on 2017/06/02 09:59:04 UTC

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

sunjincheng created CALCITE-1827:
------------------------------------

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