get date without time where sql code example

Example 1: sql server current date without time

SELECT CAST (GETDATE() AS DATE)

Example 2: sql server current time without date

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