[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..
더보기
[JavaScript] 날짜 계산
var monarr = new Array(31,28,31,30,31,30,31,31,30,31,30,31); /************************************************************************************ getDateDays(date) : 날자의 총일수를 리턴하는 함수 사용예) getDateDaus('20040101'); *************************************************************************************/ function getDateDays(date) { var year = new Number(date.substring(0,4)); var month = new Number(d..
더보기
[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..
더보기
