Posted By

flurk118 on 02/23/09

Tagged

Viewed 790 times

Favorited by 0 user(s)

/ Published in: SQL

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

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

http://microsoftmiles.blogspot.com/2006/11/remove-time-from-datetime-in-sql-server.html

Comment:

You need to login to post a comment.