Oracle中利用SQL语句显示本月日历
01
select max(decode(dow, 1, d, null)) Sun,
02
max(decode(dow, 2, d, null)) Mon,
03
max(decode(dow, 3, d, null)) Tue,
04
max(decode(dow, 4, d, null)) Wed,
05
max(decode(dow, 5, d, null)) Thu,
06
max(decode(dow, 6, d, null)) Fri,
07
max(decode(dow, 7, d, null)) Sat
08
from (select rownum d, www.2cto.com
09
rownum - 2 +
10
to_number(to_char(trunc(sysdate, 'MM'), 'D')) p,
11
to_char(trunc(sysdate, 'MM') -1 + rownum, 'D') dow
12
from all_objects
13
where rownum <=
14
to_number(to_char(last_day(to_date(sysdate)), 'DD')))
15
group by trunc(p / 7)