Where The Streets Have No Name

해당 월의 몇번째 주인가? 본문

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;
'Developement/DataBase' Related Articles more