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? 1) Run a script that creates an unload file holding integers from one to 36891 1| 2| 3| ... 2) create your table with the column defined as integer 3) load the table with the file 4) alter the column type to date -- ______________________________________________________________________ | Colin McGrath cmm@trac3000.ueci.com | | Raytheon Engineers & Constructors, Inc. (215) 422-4144 | | Phila, PA, USA | | Any opinions I state are my own and not necessarily of my employer | |____________________________________________________________________|