advanced code snippet search

Posted By

nivlam on 12/06/09


Tagged


Versions (?)

Return date only from datetime

 / Published in: SQL
 
Expand | Embed | Plain Text 
  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.