Clever, or not? date conversion to Date (use when date stored as integer)

Post date: Dec 10, 2009 8:29:36 AM

SELECT YEAR(getdate()) * 10000 + MONTH(getdate()) * 100 + DAY(getdate())