How to return only the Date from a SQL Server DateTime datatype?

Forums SQLHow to return only the Date from a SQL Server DateTime datatype?
Staff asked 7 months ago

Answers (1)

Add Answer
Umang Ramani Marked As Accepted
Staff answered 7 months ago

Try this one : SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))

 

Subscribe

Select Categories