Question

oracle 取今天23点50分到明天2点

oracle 取今天23点50分到明天凌晨2点 的sql

Answer 1

Select * From Table1 Where credate
Between to_date(to_char(trunc(Sysdate),'yyyy-mm-dd')||' 23:50:00','yyyy-mm-dd hh24:mi:ss')
And to_date(to_char(trunc(Sysdate)+1,'yyyy-mm-dd')||' 02:00:00','yyyy-mm-dd hh24:mi:ss');

Answer 2

select trunc(sysdate)+1-10*(1/24/60/60),
trunc(sysdate)+1+2/24
from dual;

select to_date(to_char(sysdate,'YYYYMMDD')||'2350','YYYYMMDDHH24MI')
,to_date(to_char(sysdate+1,'YYYYMMDD')||'02','YYYYMMDDHH24')
from dual