Just Code‎ > ‎

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

posted Dec 10, 2009, 12:29 AM by Peter Henell   [ updated Jan 25, 2010, 5:56 AM ]
SELECT YEAR(getdate()) * 10000 + MONTH(getdate()) * 100 + DAY(getdate())
Comments