得到oracle时间对应是星期几

SELECT decode(to_char(to_date('2011-04-03','YYYY-MM-DD'),'d')-1,'0','7',to_char(to_date('2011-04-03','YYYY-MM-DD'),'d')-1) as dayNum FROM DUAL SELECT decode(to_char(to_date('2011-04-03','YYYY-MM-DD'),'d')-1,'0','7',to_char(to_date('2011-04-03','YYYY-MM-DD'),'d')-1) as dayNum FROM DUAL