how do you get the date without the time in sql code example
Example 1: sql server current date without time
SELECT CAST (GETDATE() AS DATE)
Example 2: sql display today's date
SELECT getdate()
SELECT CAST (GETDATE() AS DATE)
SELECT getdate()