SELECT
SUM (
EXTRACT (
epoch
FROM
(to_timestamp('2019-09-19 11:15:20', 'yyyy-MM-dd HH24:mi:ss') - to_timestamp('2019-09-19 11:15:00', 'yyyy-MM-dd HH24:mi:ss'))
)
) AS onlinetime
FROM
dual
PG数据库查询两个时间相差秒数
最新推荐文章于 2024-04-24 14:48:33 发布