数据库存入年月日、星期、节假日

数据库存入年月日、星期、节假日

ORACLE

1.建表语句

CREATE TABLE "T_WEEKJUDGE" (
"DATEDATA" VARCHAR2(10 BYTE) NOT NULL ,
"WEEK" NUMBER(1) NOT NULL ,
"HOLIDAY" NUMBER DEFAULT 0  NOT NULL 
)
LOGGING
NOCOMPRESS
NOCACHE
;
COMMENT ON COLUMN "T_WEEKJUDGE"."DATEDATA" IS '日期';
COMMENT ON COLUMN "T_WEEKJUDGE"."WEEK" IS '星期';
COMMENT ON COLUMN "T_WEEKJUDGE"."HOLIDAY" IS '节假日（1代表节假日2代表因节假日补上班）';

2.存储过程

CREATE OR REPLACE 
PROCEDURE "WEEK_JUDGE"
AS
BEGIN 
FOR i in 0 .. 20000 LOOP
	INSERT INTO T_WEEKJUDGE(DATEDATA,WEEK) VALUES (TO_CHAR(SYSDATE+i,'YYYY-MM-DD'),TO_CHAR(SYSDATE+i,'D'));
END LOOP;
END;

3.备注内容

查询语句：查看两个日期间的天数。

select floor(to_date(&