IBM DB2计算两个时间戳记间的时间差

最新推荐文章于 2024-08-13 18:00:00 发布

于额宝

最新推荐文章于 2024-08-13 18:00:00 发布

阅读量3k

点赞数 2

分类专栏：数据库

本文链接：https://blog.csdn.net/m0_38133337/article/details/86704493

版权

数据库专栏收录该内容

1 篇文章 0 订阅

订阅专栏

DB2本身的内置函数，缺点是是近似值，用法如下：

SELECT

timestampdiff (256, char(timestamp('2017-05-27 23:00:00') - timestamp('2017-05-25 10:40:00'))) AS "间隔年",

timestampdiff (128, char(timestamp('') - timestamp(''))) AS "间隔季度",

timestampdiff (64, char(timestamp('') - timestamp(''))) AS "间隔月",

timestampdiff (32, char(timestamp('') - timestamp(''))) AS "间隔周",

timestampdiff (16, char(timestamp('') - timestamp(''))) AS "间隔日",

timestampdiff (8, char(timestamp('') - timestamp(''))) AS "间隔时",

timestampdiff (4, char(timestamp('') - timestamp(''))) AS "间隔分",

timestampdiff (2, char(timestamp('') - timestamp(''))) AS "间隔秒"

FROM SYSIBM.SYSDUMMY1;