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