get date part of getdate sql server code example

Example: sql DATE = GETDATE()

CAST(GETDATE() AS DATE)