Re: Date Table
rmcquire@tsi.gte.com wrote:
: I am sure this is a very simple question, but I will ask it anyway. I want to
: create a table with a series of dates from 1/1/1900 to 1/1/2001. What is the
: EASIEST way to go about this?
100 * 366 = 36600 days
CREATE TABLE Numerals ( Num INTEGER );
CREATE TABLE Numbers ( Num INTEGER );--
INSERT INTO Numerals VALUES ( 0 );
INSERT INTO Numerals VALUES ( 1 );
INSERT INTO Numerals VALUES ( 2 );
INSERT INTO Numerals VALUES ( 3 );
INSERT INTO Numerals VALUES ( 4 );
INSERT INTO Numerals VALUES ( 5 );
INSERT INTO Numerals VALUES ( 6 );
INSERT INTO Numerals VALUES ( 7 );
INSERT INTO Numerals VALUES ( 8 );
INSERT INTO Numerals VALUES ( 9 );--
INSERT INTO NumbersSELECT N1.Num * 10000 + N2.Num * 1000 + N3.Num * 100 + N4.Num * 10 + N5.Num
FROM Numerals N1, Numerals N2, Numerals N3, Numerals N4, Numerals N5;
--
CREATE TABLE Dates
(
Day Date NOT NULL
);--
DELETE FROM Dates WHERE 1 = 1;--
INSERT INTO Dates
SELECT DATE('01-01-1900') + (N1.Num * N2.Num) UNITS DAY
FROM Numbers N1, Numerals N2
WHERE N2.Num < 5;