On Tue, Jun 10, 2008 at 10:10 PM, Anthony Wilson <amwilson@xxxxxxxxxxxx> wrote: > Argh!! Why don't people store dates as DATESs??? > It's perfectly normal (yes, that was a pun) to store dates in this manner in a DW environment. That said, the way it was done in this example wasn't so good. It would be better if the date were stored with the data, and the day_id, month_id, etc, were stored in a separate date table. See Kimball's "Data Warehouse Toolkit" for a good example of that. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist