Advanced Search

Return to Snippet

Revision: 11906
at February 23, 2009 10:41 by flurk118
Initial Code 
http://microsoftmiles.blogspot.com/2006/11/remove-time-from-datetime-in-sql-server.html
Initial URL 









Initial Description





select cast(floor(cast(getdate() as float)) as datetime)









Initial Title





Remove time from datetime









Initial Tags





sql









Initial Language





SQL