select to_char('2011-05-01','day') as weekday from dual
返回 星期天
select to_char(to_date('2011-11-07', 'yyyy-mm-dd'), 'WW') week from dual ;
返回这一天在一年里的第几个星期
select to_char(to_date('2011-02-28', 'yyyy-mm-dd'), 'W') week from dual ;
返回这一天在在当月里的第几个星期