You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@flink.apache.org by "jackylau (Jira)" <ji...@apache.org> on 2022/08/11 12:27:00 UTC
[jira] [Created] (FLINK-28929) Add built-in datediff function.
jackylau created FLINK-28929:
--------------------------------
Summary: Add built-in datediff function.
Key: FLINK-28929
URL: https://issues.apache.org/jira/browse/FLINK-28929
Project: Flink
Issue Type: Improvement
Components: Table SQL / API
Affects Versions: 1.16.0
Reporter: jackylau
Fix For: 1.16.0
Syntax:
{code:java}
DATEDIFF(expr1,expr2){code}
* [{{}}|https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_datediff] [{{}}|https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_datediff]
Returns:
returns _{{expr1}}_ − _{{expr2}}_ expressed as a value in days from one date to the other. _{{expr1}}_ and _{{expr2}}_ are date or date-and-time expressions. Only the date parts of the values are used in the calculation.
This function returns {{NULL}} if _{{expr1}}_ or _{{expr2}}_ is {{{}NULL{}}}.
Examples:
{code:java}
> SELECT DATEDIFF('2007-12-31 23:59:59','2007-12-30');
-> 1
> SELECT DATEDIFF('2010-11-30 23:59:59','2010-12-31');
-> -31{code}
See more:
* mysql: [https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_datediff|https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html#function_conv]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)