TheSQLGuru (6/2/2014)
I call "daughter distraction" on that one Lynn! 🙂 Actually I have seen, and used myself often, int dates stored as CCYYMMDD in data warehouses. I think a lot of the reasoning for that went away with the DATE data type though. I would love to see a good study done of the plusses and minuses of each on modern systems.
Well, if you store a date as an integer in the format CCYYMMDD you have to use the INT data type.
🙂