Answers for "get date in sql server without time"

sql server current date without time

SELECT CAST (GETDATE() AS DATE)

Posted by: Guest on May-26-2020

sql server current time without date

select CAST(GETDATE() as time(0))

Posted by: Guest on May-26-2020

Code answers related to "get date in sql server without time"