in sql server to get the date part of getdate code example Example: sql DATE = GETDATE() CAST(GETDATE() AS DATE)