如何显示一周内的日期和周几,各位学兄，学姐帮帮忙

Question

例如今天是18号，则为
2012-8-13 星期一
...
2012-8-19 星期天

Answer 1

SQL> select to_char(next_day(sysdate-7, '星期一')+rownum-1, 'yyyy-mm-dd')日期, to_char(next_day(sysdate-7, '星期一')+rownum-1, 'day') 周几 from dual connect by rownum<8;日期                 周几                                                       
-------------------- ------------------------                                   
2012-08-13           星期一                                                     
2012-08-14           星期二                                                     
2012-08-15           星期三                                                     
2012-08-16           星期四                                                     
2012-08-17           星期五                                                     
2012-08-18           星期六                                                     
2012-08-19           星期日                                                     已选择7行。

Answer 2

select to_char(next_day(sysdate-7, '星期一')+rownum-1, 'yyyy-mm-dd')日期, to_char(next_day(sysdate-7, '星期一')+rownum-1, 'day') 周几 from dual connect by rownum<8;