/ Published in: SQL
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
SELECT CAST(FLOOR(CAST(Getdate() AS FLOAT))AS Datetime) SELECT DateAdd(DAY, 0, DateDiff(DAY, 0, Getdate()))
SELECT CAST(FLOOR(CAST(Getdate() AS FLOAT))AS Datetime) SELECT DateAdd(DAY, 0, DateDiff(DAY, 0, Getdate()))