如何找出两个时间戳之间的差异，并从差异中只得到小时和分钟？我试着使用提取函数或直接做减法，但没有得到预期的结果。
select (to_timestamp('29-09-22 2:27:48.696000000 PM +05:30') - systimestamp)col from dual;
数据库版本：Oracle SQL Developer(18c)
0mkxixxg1#
使用EXTRACT：
EXTRACT
SELECT EXTRACT(DAY FROM diff)*24 + EXTRACT(HOUR FROM diff) AS hours, EXTRACT(MINUTE FROM diff) AS minutes FROM ( select TIMESTAMP '2022-09-29 14:27:48.696000000 +05:30' - systimestamp AS diff from dual );
以下哪项输出：
小时|分钟
23|41
fiddle
1条答案
按热度按时间0mkxixxg1#
使用
EXTRACT：以下哪项输出：
小时|分钟
23|41
fiddle