Posted By

nivlam on 12/06/09


Tagged


Versions (?)

Return date only from datetime


 / Published in: SQL
 

  1. SELECT Cast(Floor(Cast(Getdate() AS Float))AS Datetime)
  2.  
  3. SELECT DateAdd(Day, 0, DateDiff(Day, 0, Getdate()))

Report this snippet  

You need to login to post a comment.