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-07-04 16:34:12 发布