作者：卖火柴的茹公主 | 来源：互联网 | 2014-07-09 16:02
Oracle中利用SQL语句显示本月日历01selectmax(decode(dow,1,d,null))Sun,02max(decode(dow,2,d,null))Mon,03max(decode(dow,3,d,null))Tue,04max(decode(dow,4,...
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, &＃39;MM&＃39;), &＃39;D&＃39;)) p,
11
to_char(trunc(sysdate, &＃39;MM&＃39;) -1 + rownum, &＃39;D&＃39;) dow
12
from all_objects
13
where rownum <=
14
to_number(to_char(last_day(to_date(sysdate)), &＃39;DD&＃39;)))
15
group by trunc(p / 7)
京公网安备 11010802041100号 | 京ICP备19059560号-4 | PHP1.CN 第一PHP社区 版权所有