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

사용자 도구

사이트 도구

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

차이

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

차이 보기로 링크

양쪽 이전 판 이전 판
다음 판 		이전 판
기술문서:레퍼런스:자료:휴일:2041-2050 [2025/12/02 16:47]
carlito76 		기술문서:레퍼런스:자료:휴일:2041-2050 [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>
  
줄 80: 줄 83:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20410713', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20410713', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20410714', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20410714', NULL, '일요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20410717', '제헌절', '수요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20410720', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20410720', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20410721', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20410721', NULL, '일요일');
줄 199: 줄 203:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20420712', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20420712', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20420713', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20420713', NULL, '일요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20420717', '제헌절', '목요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20420719', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20420719', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20420720', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20420720', NULL, '일요일');
줄 316: 줄 321:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20430711', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20430711', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20430712', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20430712', NULL, '일요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20430717', '제헌절', '금요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20430718', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20430718', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20430719', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20430719', NULL, '일요일');
줄 435: 줄 441:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20440710', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20440710', NULL, '일요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20440716', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20440716', NULL, '토요일');
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20440717', NULL, '일요일');+INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20440717', '제헌절', '일요일'); 
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20440718', '대체공휴일', '월요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20440723', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20440723', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20440724', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20440724', NULL, '일요일');
줄 553: 줄 560:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20450715', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20450715', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20450716', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20450716', NULL, '일요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20450717', '제헌절', '월요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20450722', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20450722', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20450723', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20450723', NULL, '일요일');
줄 672: 줄 680:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20460714', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20460714', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20460715', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20460715', NULL, '일요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20460717', '제헌절', '화요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20460721', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20460721', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20460722', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20460722', NULL, '일요일');
줄 789: 줄 798:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20470713', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20470713', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20470714', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20470714', NULL, '일요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20470717', '제헌절', '수요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20470720', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20470720', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20470721', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20470721', NULL, '일요일');
줄 905: 줄 915:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20480711', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20480711', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20480712', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20480712', NULL, '일요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20480717', '제헌절', '금요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20480718', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20480718', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20480719', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20480719', NULL, '일요일');
줄 1023: 줄 1034:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20490710', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20490710', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20490711', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20490711', NULL, '일요일');
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20490717', NULL, '토요일');+INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20490717', '제헌절', '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20490718', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20490718', NULL, '일요일');
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20490719', '대체공휴일', '월요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20490724', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20490724', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20490725', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20490725', NULL, '일요일');
줄 1140: 줄 1152:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20500710', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20500710', NULL, '일요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20500716', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20500716', NULL, '토요일');
-INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20500717', NULL, '일요일');+INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20500717', '제헌절', '일요일'); 
 +INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20500718', '대체공휴일', '월요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20500723', NULL, '토요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20500723', NULL, '토요일');
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20500724', NULL, '일요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20500724', NULL, '일요일');
줄 1198: 줄 1211:
 ===== 임시공휴일 ===== ===== 임시공휴일 =====
 <sxh sql; gutter: true;> <sxh sql; gutter: true;>
--- FIXME+-- 미정
 </sxh> </sxh>
  
 ===== 선거일 ===== ===== 선거일 =====
 <sxh sql; gutter: true;> <sxh sql; gutter: true;>
--- FIXME+-- 미정
 </sxh> </sxh>
  
줄 1230: 줄 1243:
 INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20500501', '근로자의 날', '목요일'); INSERT INTO jd_holiday (holiday_dt, holiday_nm, holiday_dow) VALUES ('20500501', '근로자의 날', '목요일');
 </sxh> </sxh>
 +
 +{{tag>"주말ㆍ공휴일"}}
  

문서 도구