Re: Date Table

Posted in 1998

Paul Brown — 20 Oct 1998 20:15:53 GMT — source: Informix-list mailing list archive (1991-1998)

Paul Brown (pbrown@triplerock.Berkeley.EDU) wrote: : INSERT INTO Dates : SELECT DATE('01-01-1900') + (N1.Num * N2.Num) UNITS DAY : FROM Numbers N1, Numerals N2 : WHERE N2.Num < 5; Duh! INSERT INTO Dates SELECT DATE('01-01-1900') + N1.Num UNITS DAY FROM Numbers N1 WHERE N1.Num <= 36600;