db2时间相减获取相隔年月日时分秒方法

最新推荐文章于 2023-03-23 11:44:20 发布

原创最新推荐文章于 2023-03-23 11:44:20 发布 · 3.1k 阅读

11 ·

CC 4.0 BY-SA版权

笔记专栏收录该内容

5 篇文章

订阅专栏

本文提供了一个SQL查询示例，展示了如何使用TIMESTAMPDIFF函数来计算两个不同时间戳之间的间隔，包括年、季度、月、周、日、小时、分钟及秒。

SELECT
timestampdiff (256, char(timestamp(‘2013-12-30 20:30:30’) - timestamp(‘2001-09-26 15:24:23’))) AS “间隔年”,
timestampdiff (128, char(timestamp(‘2013-12-30 20:30:30’) - timestamp(‘2001-09-26 15:24:23’))) AS “间隔季度”,
timestampdiff (64, char(timestamp(‘2013-12-30 20:30:30’) - timestamp(‘2001-09-26 15:24:23’))) AS “间隔月”,
timestampdiff (32, char(timestamp(‘2013-12-30 20:30:30’) - timestamp(‘2001-09-26 15:24:23’))) AS “间隔周”,
timestampdiff (16, char(timestamp(‘2013-12-30 20:30:30’) - timestamp(‘2001-09-26 15:24:23’))) AS “间隔日”,
timestampdiff (8, char(timestamp(‘2013-12-30 20:30:30’) - timestamp(‘2001-09-26 15:24:23’))) AS “间隔时”,
timestampdiff (4, char(timestamp(‘2013-12-30 20:30:30’) - timestamp(‘2001-09-26 15:24:23’))) AS “间隔分”,
timestampdiff (2, char(timestamp(‘2013-12-30 20:30:30’) - timestamp(‘2001-09-26 15:24:23’))) AS “间隔秒”
FROM SYSIBM.SYSDUMMY1;

百度出来了，以此记录！