Answers for "getting date without timestamp in sql for date column"

sql server current date without time

SELECT CAST (GETDATE() AS DATE)

Posted by: Guest on May-26-2020

sql datetime as date

SELECT 
    CONVERT(DATE, GETDATE()) date;

Posted by: Guest on August-20-2020

Code answers related to "getting date without timestamp in sql for date column"