select to_char((trunc(sysdate)+trunc((
日期-trunc(sysdate))*24)/24),'hh24') ||'-'||to_char((trunc(sysdate)+trunc((日期-trunc(sysdate))*24+1)/24),'hh24') 时间段, avg(统计
字段平均值),sum(统计字段和),count(*) "字段条数"from 表名where trunc(日期)=to_date(&day,'yyyymmdd') group by to_char((trunc(sysdate)+trunc((日期-trunc(sysdate))*24)/24),'hh24')||'-'|| to_char((trunc(sysdate)+trunc((日期-trunc(sysdate))*24+1)/24),'hh24') order by 1查询今天上午八
点到九点内的所有记录:
select * from tablename where to_days(now())=to_days(datetimecolume) and hour(datetimecolume)=8
评论列表(0条)