I cannot recall where I got the data before so I'm asking here:
Where can I get or how can I generate standard date/time/calendar data?
The table would consist of columns such as:
main_date -- generate date mm/dd/yyyy date_id -- yyyymmdd day -- Monday, Tuesday time -- hh:ss time_id -- 120000 (or some int equivalent for each minute/second?)
and a few more columns maybe like the year, month, date (dd) - etc - which I cannot remember at the moment. Then there are, if I recall correctly, columns that cover timezone changes --
I'm not sure if the data was created by a script made by another DBA in my previous job, or if it is available on the internet - I can't seem to find it, but I am likely to believe it is somewhere out there. It could also have been a table already created and just ready for download (script?) -- The data I'm referring to doesn't change. Say, for example, 2013-06-30 will forever be a Sunday - nothing will change that. 12:00 PM will always be 12:00 PM. There are 24 hours each day - that's also constant.. I apologize if this is vague..
I'm really looking for a table that can be looked-up since the values per day per year will never change.