2025-03-30 02:48:03
2025-03-30 05:46:03
select ceil(to_date('2013-11-08 00:00:00','yyyy-mm-dd hh24:mi:ss')-to_date('2013-11-07 23:59:59','yyyy-mm-dd hh24:mi:ss')) from dual
用ceil,向上取整就好了嘛
2025-03-30 00:27:43
select sysdate-日期 from dual;
#得到的是你的那个日期和当前时间相差多少天