[ https://issues.apache.org/jira/browse/FLINK-6847?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16551928#comment-16551928
]
ASF GitHub Bot commented on FLINK-6847:
---------------------------------------
Github user hequn8128 commented on a diff in the pull request:
https://github.com/apache/flink/pull/6282#discussion_r204230534
--- Diff: docs/dev/table/tableApi.md ---
@@ -4490,6 +4490,16 @@ dateFormat(TIMESTAMP, STRING)
</td>
</tr>
+ <tr>
+ <td>
+ {% highlight text %}
+timestampDiff(unit, timestamp1, timestamp2)
--- End diff --
timestampDiff(unit, timestamp1, timestamp2) => timestampDiff(TimeIntervalUnit, datetime1,
datetime2)
TIMESTAMP is different from DATETIME. The supported range of DATETIME is '1000-01-01 00:00:00'
to '9999-12-31 23:59:59', while TIMESTAMP has a range of '1970-01-01 00:00:01' UTC to '2038-01-19
03:14:07' UTC
> Add TIMESTAMPDIFF supported in TableAPI
> ---------------------------------------
>
> Key: FLINK-6847
> URL: https://issues.apache.org/jira/browse/FLINK-6847
> Project: Flink
> Issue Type: Sub-task
> Components: Table API & SQL
> Affects Versions: 1.4.0
> Reporter: sunjincheng
> Priority: Major
> Labels: pull-request-available, starter
>
> see FLINK-6813
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
|