sql get current 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))