sql server date without time 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))SELECT CAST (GETDATE() AS DATE)select CAST(GETDATE() as time(0))