匿名通过本文主要向大家介绍了代码片段,代码分享,PHP代码分享,Java代码分享,Ruby代码分享,Python代码分享,HTML代码分享,CSS代等相关知识,希望本文的分享对您有所帮助
Create Table FinancialYear (fiscal_year INTEGER NOT NULL PRIMARY KEY, start_date DATE NOT NULL, CHECK ((EXTRACT(YEAR FROM start_date)=fiscal_year-1) AND (EXTRACT (MONTH FROM start_date)=10) AND (EXTRACT(DAY FROM start_date)=1), end_date DATE NOT NULL, CONSTRAINT valid_end_date CHECK ((EXTRACT (YEAR FROM end_date)=fiscal_year) AND (EXTRACT (MONTH FROM end_date)=9) AND (EXTRACT (DAY FROM end_date)=30)))