oracle 时间相关

判断当天：

select * from table_name

where v_date>=trunc(sysdate)

获取今天小时列表，两种方法都可以

select level,to_char(trunc(sysdate)+level/24-1,'HH24') as dat 
from dual
connect by level <=  ROUND(TO_NUMBER(sysdate - trunc(sysdate)) * 24)

select to_char(sysdate +(rownum - 1) / 24,'hh24') AS shijian from DUAL connect by rownum <= 24 ORDER BY shijian

文章来源: blog.csdn.net，作者：网奇，版权归原作者所有，如需转载，请联系作者。

原文链接：blog.csdn.net/jacke121/article/details/70247400