The GETDATE() command returns the date value only. TIME() returns the time value. code example

Example 1: sql server current date without time

SELECT CAST (GETDATE() AS DATE)

Example 2: sql DATE = GETDATE()

CAST(GETDATE() AS DATE)