advanced code snippet search

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)

Expand | Embed | Plain Text 
  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.