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

사용자 도구

사이트 도구

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

차이

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

차이 보기로 링크

양쪽 이전 판 이전 판
다음 판 		이전 판
기술문서:레퍼런스:자료:휴일:2021-2030 [2025/10/21 12:45]
carlito76 		기술문서:레퍼런스:자료:휴일:2021-2030 [2026/02/12 12:48] (현재)
carlito76
줄 1: 줄 1:
 {{htmlmetatags> {{htmlmetatags>
-metatag-description=(휴일 데이터, 토요일, 일요일, 법정공휴일, 대체공휴일, 임시공휴일, 데이터베이스, DBMS, SQL, MySQL, MariaDB, MSSQL, Oracle, Tibero, PostgreSQL) +metatag-description=(휴일 데이터, 토요일, 일요일, 법정공휴일, 대체공휴일, 임시공휴일, 선거일, 근로자의 날, 데이터베이스, DBMS, SQL, MySQL, MariaDB, MSSQL, Oracle, Tibero, PostgreSQL) 
-metatag-og:description=(휴일 데이터, 토요일, 일요일, 법정공휴일, 대체공휴일, 임시공휴일, 데이터베이스, DBMS, SQL, MySQL, MariaDB, MSSQL, Oracle, Tibero, PostgreSQL)+metatag-og:description=(휴일 데이터, 토요일, 일요일, 법정공휴일, 대체공휴일, 임시공휴일, 선거일, 근로자의 날, 데이터베이스, DBMS, SQL, MySQL, MariaDB, MSSQL, Oracle, Tibero, PostgreSQL)
 }} }}
  
줄 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]]
  
-===== 주말ㆍ공휴일 =====+===== 토요일, 일요일, 법정공휴일, 대체공휴일 =====
 <sxh sql; gutter: true;> <sxh sql; gutter: true;>
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20210101', '신정', '금요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20210101', '신정', '금요일');
줄 336: 줄 340:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20230930', '추석', '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20230930', '추석', '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20231001', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20231001', NULL, '일요일');
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20231002', '임시공휴일', '월요일'); 
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20231003', '개천절', '화요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20231003', '개천절', '화요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20231007', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20231007', NULL, '토요일');
줄 455: 줄 458:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20240928', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20240928', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20240929', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20240929', NULL, '일요일');
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20241001', '임시공휴일', '화요일'); 
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20241003', '개천절', '목요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20241003', '개천절', '목요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20241005', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20241005', NULL, '토요일');
줄 494: 줄 496:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20250125', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20250125', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20250126', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20250126', NULL, '일요일');
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20250127', '임시공휴일', '월요일'); 
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20250128', '설날', '화요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20250128', '설날', '화요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20250129', '설날', '수요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20250129', '설날', '수요일');
줄 527: 줄 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, '토요일');
줄 668: 줄 669:
 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, '일요일');
줄 743: 줄 745:
 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, '일요일');
줄 784: 줄 786:
 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, '일요일');
줄 904: 줄 907:
 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, '일요일');
줄 1023: 줄 1027:
 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, '일요일');
줄 1116: 줄 1121:
 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 ('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', '부처님 오신 날', '목요일');
줄 1140: 줄 1145:
 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, '일요일');
줄 1195: 줄 1201:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20301228', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20301228', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20301229', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20301229', NULL, '일요일');
 +</sxh>
 +
 +===== 임시공휴일 =====
 +<sxh sql; gutter: true;>
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20231002', '임시공휴일', '월요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20241001', '임시공휴일', '화요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20250127', '임시공휴일', '월요일');
 +</sxh>
 +
 +===== 선거일 =====
 +<sxh sql; gutter: true;>
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20220309', '제20대 대통령선거', '수요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20220601', '제8회 전국동시지방선거', '수요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20240410', '제22대 국회의원선거', '수요일');
 +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 ('20280412', '제23대 국회의원선거', '수요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20300327', '제22대 대통령선거', '수요일');
 </sxh> </sxh>
  
줄 1222: 줄 1246:
 </sxh> </sxh>
  
-===== 선거일 ===== +{{tag>"주말ㆍ공휴일"}}
-<sxh sql; gutter: true;> +
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20220309', '제20대 대통령선거', '수요일'); +
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20220601', '제8회 전국동시지방선거', '수요일'); +
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20240410', '제22대 국회의원선거', '수요일'); +
-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회 전국동시지방선거', '수요일'); +
-</sxh>+
  

문서 도구