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)
