Posted By

flurk118 on 02/23/09


Tagged

sql DateTime


Versions (?)

Remove time from datetime


 / Published in: SQL
 

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

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

Report this snippet  

You need to login to post a comment.