Answers for "how to get only date without time in sql"

sql server current date without time

SELECT CAST (GETDATE() AS DATE)

Posted by: Guest on May-26-2020

sql getdate date only

-- MS SQL Server
SELECT CAST(getdate() AS date);
SELECT CAST(getdate() AS varchar(10));

Posted by: Guest on March-26-2021

Code answers related to "how to get only date without time in sql"