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

사용자 도구

사이트 도구

기술문서:레퍼런스:자료:휴일:2021-2030

차이

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

차이 보기로 링크

양쪽 이전 판 이전 판
다음 판 		이전 판
기술문서:레퍼런스:자료:휴일:2021-2030 [2025/10/21 12:58]
carlito76 		기술문서:레퍼런스:자료:휴일:2021-2030 [2026/04/24 14:53] (현재)
carlito76
줄 7: 줄 7:
  
 <note tip> <note tip>
-토요일, 일요일, 법정공휴일, 대체공휴일, 임시공휴일, 선거일, 근로자의 날 데이터입니다.+휴일 데이터입니다.\\ 
 +- 토요일, 일요일\\ 
 +- 법정공휴일, 대체공휴일\\ 
 +- 임시공휴일, 선거일, 근로자의 날
 </note> </note>
  
-  * [[기술문서:레퍼런스:자료:휴일:2021-2030|2021-2030]] +  * [[기술문서:레퍼런스:자료:휴일:주말-공휴일|주말ㆍ공휴일]] 
-  * [[기술문서:레퍼런스:자료:휴일:2031-2040|2031-2040]] +    * [[기술문서:레퍼런스:자료:휴일:2021-2030|2021-2030]] 
-  * [[기술문서:레퍼런스:자료:휴일:2041-2050|2041-2050]]+    * [[기술문서:레퍼런스:자료:휴일:2031-2040|2031-2040]] 
 +    * [[기술문서:레퍼런스:자료:휴일:2041-2050|2041-2050]]
  
 ===== 토요일, 일요일, 법정공휴일, 대체공휴일 ===== ===== 토요일, 일요일, 법정공휴일, 대체공휴일 =====
줄 524: 줄 528:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20250503', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20250503', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20250504', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20250504', NULL, '일요일');
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20250505', '어린이날, 부처님 오신 날', '월요일');+INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20250505', '부처님 오신 날, 어린이날', '월요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20250506', '대체공휴일', '화요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20250506', '대체공휴일', '화요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20250510', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20250510', NULL, '토요일');
줄 641: 줄 645:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20260425', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20260425', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20260426', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20260426', NULL, '일요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20260501', '노동절', '금요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20260502', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20260502', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20260503', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20260503', NULL, '일요일');
줄 665: 줄 670:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20260711', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20260711', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20260712', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20260712', NULL, '일요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20260717', '제헌절', '금요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20260718', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20260718', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20260719', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20260719', NULL, '일요일');
줄 740: 줄 746:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270227', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270227', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270228', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270228', NULL, '일요일');
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270301', NULL, '월요일');+INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270301', '삼일절', '월요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270306', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270306', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270307', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270307', NULL, '일요일');
줄 757: 줄 763:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270424', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270424', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270425', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270425', NULL, '일요일');
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270501', NULL, '토요일');+INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270501', '노동절', '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270502', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270502', NULL, '일요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270505', '어린이날', '수요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270505', '어린이날', '수요일');
줄 781: 줄 787:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270710', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270710', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270711', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270711', NULL, '일요일');
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270717', NULL, '토요일');+INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270717', '제헌절', '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270718', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270718', NULL, '일요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270719', '대체공휴일', '월요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270724', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270724', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270725', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270725', NULL, '일요일');
줄 876: 줄 883:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20280429', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20280429', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20280430', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20280430', NULL, '일요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20280501', '노동절', '월요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20280502', '부처님 오신 날', '화요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20280502', '부처님 오신 날', '화요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20280505', '어린이날', '금요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20280505', '어린이날', '금요일');
줄 901: 줄 909:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20280715', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20280715', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20280716', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20280716', NULL, '일요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20280717', '제헌절', '월요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20280722', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20280722', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20280723', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20280723', NULL, '일요일');
줄 995: 줄 1004:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20290428', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20290428', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20290429', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20290429', NULL, '일요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20290501', '노동절', '화요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20290505', '어린이날', '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20290505', '어린이날', '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20290506', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20290506', NULL, '일요일');
줄 1020: 줄 1030:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20290714', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20290714', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20290715', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20290715', NULL, '일요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20290717', '제헌절', '화요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20290721', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20290721', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20290722', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20290722', NULL, '일요일');
줄 1112: 줄 1123:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20300427', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20300427', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20300428', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20300428', NULL, '일요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20300501', '노동절', '수요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20300504', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20300504', NULL, '토요일');
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20300505', NULL, '일요일');+INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20300505', '어린이날', '일요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20300506', '대체공휴일', '월요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20300506', '대체공휴일', '월요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20300509', '부처님 오신 날', '목요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20300509', '부처님 오신 날', '목요일');
줄 1137: 줄 1149:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20300713', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20300713', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20300714', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20300714', NULL, '일요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20300717', '제헌절', '수요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20300720', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20300720', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20300721', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20300721', NULL, '일요일');
줄 1208: 줄 1221:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20250603', '제21대 대통령선거', '화요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20250603', '제21대 대통령선거', '화요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20260603', '제9회 전국동시지방선거', '수요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20260603', '제9회 전국동시지방선거', '수요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20280412', '제23대 국회의원선거', '수요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20300327', '제22대 대통령선거', '수요일');
 </sxh> </sxh>
  
줄 1217: 줄 1232:
 DELETE FROM jd_holiday WHERE holiday_dt = '20240501'; DELETE FROM jd_holiday WHERE holiday_dt = '20240501';
 DELETE FROM jd_holiday WHERE holiday_dt = '20250501'; DELETE FROM jd_holiday WHERE holiday_dt = '20250501';
-DELETE FROM jd_holiday WHERE holiday_dt = '20260501'; 
-DELETE FROM jd_holiday WHERE holiday_dt = '20270501'; 
-DELETE FROM jd_holiday WHERE holiday_dt = '20280501'; 
-DELETE FROM jd_holiday WHERE holiday_dt = '20290501'; 
-DELETE FROM jd_holiday WHERE holiday_dt = '20300501'; 
  
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20210501', '근로자의 날', '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20210501', '근로자의 날', '토요일');
줄 1228: 줄 1238:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20240501', '근로자의 날', '수요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20240501', '근로자의 날', '수요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20250501', '근로자의 날', '목요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20250501', '근로자의 날', '목요일');
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20260501', '근로자의 날', '금요일'); 
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20270501', '근로자의 날', '토요일'); 
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20280501', '근로자의 날', '월요일'); 
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20290501', '근로자의 날', '화요일'); 
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20300501', '근로자의 날', '수요일'); 
 </sxh> </sxh>
 +
 +{{tag>"주말ㆍ공휴일"}}
  

문서 도구