Developement/DataBase
해당 월의 몇번째 주인가?
highheat
2006. 3. 31. 01:35
select floor( ((to_number(to_char(trunc(TO_DATE('20041005','YYMMDD'),'mon'),'d'))-1)+ to_number(to_char(TO_DATE('20041005','YYMMDD'),'dd'))-1) / 7 ) +1 as "몇번째 달이죠?"
from dual;
from dual;