Re: Simplifying db queries
From: -CELKO- <jcelko212_at_earthlink.net>
Date: 4 Mar 2005 06:28:24 -0800
Message-ID: <1109946504.659283.317460_at_o13g2000cwo.googlegroups.com>
Date: 4 Mar 2005 06:28:24 -0800
Message-ID: <1109946504.659283.317460_at_o13g2000cwo.googlegroups.com>
In general they look like this:
CREATE TABLE ReportCalendar
(report_period CHAR(15 NOT NULL PRIMARY KEY,
start_date DATE NOT NULL,
end_date DATE NOT NULL,
CHECK (start_date < end_date));
You use a " my_date BETWEEN start_date AND end_date" search condition to create the report. Received on Fri Mar 04 2005 - 15:28:24 CET