数据湖探索 DLI-时间函数:TIMESTAMPDIFF
时间：2025-09-18 09:34:35
下载数据湖探索 DLI用户手册完整版
复制链接到剪贴板
分享文章到微博
分享文章到朋友圈
TIMESTAMPDIFF
- 功能描述
参考语法说明，本函数功能为返回timepoint1和timepoint2之间的时间间隔，间隔的单位由第一个参数timepointunit指定。
- 语法说明
INT TIMESTAMPDIFF(timepointunit, timepoint1, timepoint2)
- 入参说明
参数名
数据类型
参数说明
timepointunit
TIMEUNIT
时间单位。取值范围为： SECOND、MINUTE、HOUR、DAY、MONTH、YEAR。
timepoint1/timepoint2
TIMESTAMP/DATE
时间点。
- 示例
- 测试语句
SELECT TIMESTAMPDIFF(DAY, TIMESTAMP '1997-04-25 10:00:00', TIMESTAMP '1997-04-28 10:00:00') AS `result`, TIMESTAMPDIFF(DAY, DATE '1997-04-25', DATE '1997-04-28') AS `result2`,TIMESTAMPDIFF(DAY, TIMESTAMP '1997-04-27 10:00:20', TIMESTAMP '1997-04-25 10:00:00') AS `result3`FROMtesttable;
- 测试结果
result
result2
result3
3
3
-2
- 测试语句
support.huaweicloud.com/sqlref-flink-dli/dli_08_15090.html
