how to use get date in sql server code example

Example: sql DATE = GETDATE()

CAST(GETDATE() AS DATE)