[
https://issues.apache.org/jira/browse/CALCITE-1827?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde resolved CALCITE-1827.
----------------------------------
Resolution: Fixed
Fix Version/s: 1.13.0
Added documentation for TIMESTAMPADD, TIMESTAMPDIFF in
http://git-wip-us.apache.org/repos/asf/calcite/commit/f5df5dd8. Thanks for the
PR, [~sunjincheng121]!
> 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
> Fix For: 1.13.0
>
>
> 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)
