Every once in a great while I need to just return the date of a date time and forget about the time part of it.
SELECT CAST(FLOOR(CAST(getDate() AS FLOAT)) AS DATETIME) as MyDate
Obviously you can replace getDate() with a column.
villelink
Ramblings of a computer programmer.
