How to return only the Date from a SQL Server DateTime datatype? – The Code Hubs

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

monika gabani Apr 23, 2022 0 211

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

0 Vote Up Vote Down

Staff asked 3 years ago

Answers (1)

Add Answer

1 Vote Up Vote Down

Umang Ramani Marked As Accepted

Staff answered 3 years ago

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