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

사용자 도구

사이트 도구

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

차이

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

차이 보기로 링크

양쪽 이전 판 이전 판
다음 판 		이전 판
기술문서:레퍼런스:자료:휴일:2021-2030 [2025/12/02 16:47]
carlito76 		기술문서:레퍼런스:자료:휴일:2021-2030 [2026/04/24 14:53] (현재)
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>
  
줄 642: 줄 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, '일요일');
줄 666: 줄 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, '일요일');
줄 758: 줄 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', '어린이날', '수요일');
줄 782: 줄 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, '일요일');
줄 877: 줄 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', '어린이날', '금요일');
줄 902: 줄 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, '일요일');
줄 996: 줄 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, '일요일');
줄 1021: 줄 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, '일요일');
줄 1113: 줄 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', '어린이날', '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20300505', '어린이날', '일요일');
줄 1138: 줄 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, '일요일');
줄 1209: 줄 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>
  
줄 1218: 줄 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', '근로자의 날', '토요일');
줄 1229: 줄 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>"주말ㆍ공휴일"}}
  

문서 도구