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

monika gabani Apr 23, 2022 0 234

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

Staff asked 2 years ago

1 Vote Up Vote Down

Umang Ramani Marked As Accepted

Staff answered 2 years ago

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

monika gabani