[Oracle Sql] 주차 구하기 월/주/요일
SELECT CAL_DATE , YEAR_NO||WEEK_NO AS MS_YEAR_WEEK , MS_START_DATE , MS_END_DATE , YEAR_NO||MONTH_NO AS MS_MONTH , YEAR_NO , WEEK_DAY , START7_WEEK , SM_WEEK_1JAN , MS_WEEK_1JAN FROM ( SELECT DT , TO_CHAR(DT,'YYYYMMDD') AS CAL_DATE , TO_CHAR(TRUNC(DT,'IW'),'YYYYMMDD') AS MS_START_DATE , TO_CHAR(TRUNC(DT,'IW')+7,'YYYYMMDD') AS MS_END_DATE , TO_CHAR(DT, 'DY') AS WEEK_DAY , TO_CHAR(DT, 'WW') AS STA..
더보기