当前位置：网站首页>Oracle calculates the difference between two dates in seconds, minutes, hours and days

Oracle calculates the difference between two dates in seconds, minutes, hours and days

2022-04-23 13:40:00 【Wangcai 2】

-- Calculate the number of seconds between the two time differences
select (sysdate-to_date('2021/12/14 17:00:00','yyyy/mm/dd hh24:mi:ss'))*24*60*60 from dual
 
-- Calculate the difference between the two time differences
select (sysdate-to_date('2021/12/14 17:00:00','yyyy/mm/dd hh24:mi:ss'))*24*60 from dual
 
-- When calculating the difference between two time differences
select (sysdate-to_date('2021/12/14 17:00:00','yyyy/mm/dd hh24:mi:ss'))*24 from dual
 
-- Calculate how many days there is between the two time differences
select sysdate-to_date('2021/12/14 17:00:00','yyyy/mm/dd hh24:mi:ss') from dual

版权声明
本文为[Wangcai 2]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204230604300916.html

边栏推荐

猜你喜欢

随机推荐