oracle中查询一个日期的24个小时

with t as(select rownum-1 rn from dual connect by rownum<=24), hoursbyday as (select to_date('2014/3/18 00:00:00', 'yyyy/mm/dd hh24:mi:ss') + (1+rn)/24 from t )
select * from hoursbyday
展开阅读全文

没有更多推荐了,返回首页