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

Asked 07 September, 2021

Viewed 2.9K times

sql sql-server tsql date datetime

Votes

SELECT GETDATE()

Returns: 2008-09-22 15:24:13.790

I want that date part without the time part: 2008-09-22 00:00:00.000

How can I get that?

Order by

Login with Social Media