[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..
더보기
[Oracle Sql] 요일 달력 쿼리 만들기
[Oracle Sql] 요일 달력 쿼리 만들기 /*****************************************************************************/--달력 쿼리 SELECT MIN (DECODE (TO_CHAR (DAYS, 'D'), 1, TO_CHAR (DAYS, 'FMDD'))) AS SUN, MIN (DECODE (TO_CHAR (DAYS, 'D'), 2, TO_CHAR (DAYS, 'FMDD'))) AS MON, MIN (DECODE (TO_CHAR (DAYS, 'D'), 3, TO_CHAR (DAYS, 'FMDD'))) AS TUE, MIN (DECODE (TO_CHAR (DAYS, 'D'), 4, TO_CHAR (DAYS, 'FMDD'))) AS WED..
더보기