SELECT YEAR(getdate()) * 10000 + MONTH(getdate()) * 100 + DAY(getdate()) |
Just Code >
|
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 ]
|