This function is the ANSI SQL equivalent to CAST(GETDATE() AS DATE). For more information, see GETDATE. See Date and time data types and functions for an overview of all the Transact-SQL date and time ...