select Count(*),to_char(exec_time,'YYYY-MM-DD hh24:')||decode(trunc(to_char(exec_time,'mi')/10),0,'00',1,'10',2,'20',3,'30',4,'40',5,'50')
from ti_c_order Where exec_time>=to_date('2008-11-17 00:00:00','YYYY-MM-DD HH24:MI:SS') And exec_time group by to_char(exec_time,'YYYY-MM-DD hh24:')||decode(trunc(to_char(exec_time,'mi')/10),0,'00',1,'10',2,'20',3,'30',4,'40',5,'50')
Order By to_char(exec_time,'YYYY-MM-DD hh24:')||decode(trunc(to_char(exec_time,'mi')/10),0,'00',1,'10',2,'20',3,'30',4,'40',5,'50')
阅读(809) | 评论(0) | 转发(0) |
