select ROUND(TO_NUMBER(to_date('2011-11-11 12:00:00','yyyy-mm-dd hh24:mi:ss') - to_date('2011-11-11 11:59:00','yyyy-mm-dd hh24:mi:ss')) * 24 * 60 * 60) from dual
oracle比较时间
最新推荐文章于 2023-01-10 17:42:46 发布
select ROUND(TO_NUMBER(to_date('2011-11-11 12:00:00','yyyy-mm-dd hh24:mi:ss') - to_date('2011-11-11 11:59:00','yyyy-mm-dd hh24:mi:ss')) * 24 * 60 * 60) from dual