잡개발자 리토의 잡위키 잡개발자 리토의 잡위키

사용자 도구

사이트 도구

기술문서:레퍼런스:자료:휴일:2041-2050

차이

문서의 선택한 두 판 사이의 차이를 보여줍니다.

차이 보기로 링크

양쪽 이전 판 이전 판
다음 판 		이전 판
기술문서:레퍼런스:자료:휴일:2041-2050 [2026/01/30 10:47]
carlito76 		기술문서:레퍼런스:자료:휴일:2041-2050 [2026/04/24 15:11] (현재)
carlito76
줄 9: 줄 9:
 휴일 데이터입니다.\\ 휴일 데이터입니다.\\
 - 토요일, 일요일\\ - 토요일, 일요일\\
-- 법정공휴일, 대체공휴일, 임시공휴일\\ +- 법정공휴일, 대체공휴일\\ 
-- 선거일, 근로자의 날+- 임시공휴일, 선거일
 </note> </note>
  
줄 58: 줄 58:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20410427', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20410427', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20410428', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20410428', NULL, '일요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20410501', '노동절', '수요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20410504', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20410504', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20410505', '어린이날', '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20410505', '어린이날', '일요일');
줄 178: 줄 179:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20420426', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20420426', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20420427', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20420427', NULL, '일요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20420501', '노동절', '목요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20420503', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20420503', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20420504', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20420504', NULL, '일요일');
줄 297: 줄 299:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20430425', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20430425', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20430426', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20430426', NULL, '일요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20430501', '노동절', '금요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20430502', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20430502', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20430503', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20430503', NULL, '일요일');
줄 416: 줄 419:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20440424', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20440424', NULL, '일요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20440430', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20440430', NULL, '토요일');
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20440501', NULL, '일요일');+INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20440501', '노동절', '일요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20440505', '부처님 오신 날, 어린이날', '목요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20440505', '부처님 오신 날, 어린이날', '목요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20440506', '대체공휴일', '금요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20440506', '대체공휴일', '금요일');
줄 535: 줄 538:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20450429', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20450429', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20450430', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20450430', NULL, '일요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20450501', '노동절', '월요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20450505', '어린이날', '금요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20450505', '어린이날', '금요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20450506', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20450506', NULL, '토요일');
줄 655: 줄 659:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20460428', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20460428', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20460429', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20460429', NULL, '일요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20460501', '노동절', '화요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20460505', '어린이날', '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20460505', '어린이날', '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20460506', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20460506', NULL, '일요일');
줄 773: 줄 778:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20470427', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20470427', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20470428', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20470428', NULL, '일요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20470501', '노동절', '수요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20470502', '부처님 오신 날', '목요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20470502', '부처님 오신 날', '목요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20470504', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20470504', NULL, '토요일');
줄 891: 줄 897:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20480425', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20480425', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20480426', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20480426', NULL, '일요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20480501', '노동절', '금요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20480502', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20480502', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20480503', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20480503', NULL, '일요일');
줄 1010: 줄 1017:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20490424', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20490424', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20490425', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20490425', NULL, '일요일');
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20490501', NULL, '토요일');+INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20490501', '노동절', '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20490502', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20490502', NULL, '일요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20490505', '어린이날', '수요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20490505', '어린이날', '수요일');
줄 1127: 줄 1134:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20500424', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20500424', NULL, '일요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20500430', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20500430', NULL, '토요일');
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20500501', NULL, '일요일');+INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20500501', '노동절', '일요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20500505', '어린이날', '목요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20500505', '어린이날', '목요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20500507', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20500507', NULL, '토요일');
줄 1211: 줄 1218:
 ===== 임시공휴일 ===== ===== 임시공휴일 =====
 <sxh sql; gutter: true;> <sxh sql; gutter: true;>
--- FIXME+-- 미정
 </sxh> </sxh>
  
 ===== 선거일 ===== ===== 선거일 =====
 <sxh sql; gutter: true;> <sxh sql; gutter: true;>
--- FIXME+-- 미정
 </sxh> </sxh>
  
-===== 근로자의 날 ===== +{{tag>"주말ㆍ공휴일"}}
-<sxh sql; gutter: true;> +
-DELETE FROM jd_holiday WHERE holiday_dt = '20410501'; +
-DELETE FROM jd_holiday WHERE holiday_dt = '20420501'; +
-DELETE FROM jd_holiday WHERE holiday_dt = '20430501'; +
-DELETE FROM jd_holiday WHERE holiday_dt = '20440501'; +
-DELETE FROM jd_holiday WHERE holiday_dt = '20450501'; +
-DELETE FROM jd_holiday WHERE holiday_dt = '20460501'; +
-DELETE FROM jd_holiday WHERE holiday_dt = '20470501'; +
-DELETE FROM jd_holiday WHERE holiday_dt = '20480501'; +
-DELETE FROM jd_holiday WHERE holiday_dt = '20490501'; +
-DELETE FROM jd_holiday WHERE holiday_dt = '20500501'; +
- +
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20410501', '근로자의 날', '수요일'); +
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20420501', '근로자의 날', '목요일'); +
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20430501', '근로자의 날', '금요일'); +
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20440501', '근로자의 날', '일요일'); +
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20450501', '근로자의 날', '월요일'); +
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20460501', '근로자의 날', '화요일'); +
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20470501', '근로자의 날', '목요일'); +
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20480501', '근로자의 날', '금요일'); +
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20490501', '근로자의 날', '토요일'); +
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20500501', '근로자의 날', '목요일'); +
-</sxh>+
  

문서 도구