Advanced Search

Return date only from datetime

/ Published in: SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. SELECT CAST(FLOOR(CAST(Getdate() AS FLOAT))AS Datetime)
  2.  
  3. SELECT DateAdd(DAY, 0, DateDiff(DAY, 0, Getdate()))

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.