Get a date without time in SQL
--Extracts the date from the date time
CAST(FLOOR(CAST(GETDATE() AS float)) AS datetime)
Never been to CodeSnippets before?
Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)