You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2017/06/05 07:12:04 UTC
[jira] [Commented] (FLINK-6811) Add TIMESTAMPADD supported in SQL
[ https://issues.apache.org/jira/browse/FLINK-6811?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16036620#comment-16036620 ]
ASF GitHub Bot commented on FLINK-6811:
---------------------------------------
GitHub user sunjincheng121 opened a pull request:
https://github.com/apache/flink/pull/4076
[FLINK-6811][table] Add TIMESTAMPADD supported in SQL
In this PR I have add `TIMESTAMPADD` supported in SQL. (the semantics keep consistent with calcite)
- [x] General
- The pull request references the related JIRA issue ("[FLINK-6811][table] Add TIMESTAMPADD supported in SQL")
- The pull request addresses only one issue
- Each commit in the PR has a meaningful commit message (including the JIRA id)
- [ ] Documentation
- Documentation has been added for new functionality
- Old documentation affected by the pull request has been updated
- JavaDoc for public methods has been added
- [x] Tests & Build
- Functionality added by the pull request is covered by tests
- `mvn clean verify` has been executed successfully locally or a Travis build has passed
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/sunjincheng121/flink FLINK-6811-PR
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/flink/pull/4076.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #4076
----
commit e602b60ff54c73a79296b077ad999cfa31955cd5
Author: sunjincheng121 <su...@gmail.com>
Date: 2017-06-04T05:34:53Z
[FLINK-6811][table] Add TIMESTAMPADD supported in SQL
----
> Add TIMESTAMPADD supported in SQL
> ---------------------------------
>
> Key: FLINK-6811
> URL: https://issues.apache.org/jira/browse/FLINK-6811
> Project: Flink
> Issue Type: Sub-task
> Components: Table API & SQL
> Reporter: sunjincheng
> Assignee: sunjincheng
>
> * Syntax
> timestampAdd (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 timestampAdd(month, 1, '2017-05-31') from tab; --> 2017-06-30 00:00:00.000
> See more: [https://issues.apache.org/jira/browse/CALCITE-1827|https://issues.apache.org/jira/browse/CALCITE-1827]
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)