Remove time from datetime - SQL Snipplr Social Repository

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