date (Transact-SQL)

SQL Server 2008 R2 Other Versions SQL Server 2014 ... Defines a date. For an overview of all Transact-SQL date and time data types and functions, see Date and Time Functions (Transact-SQL). For information and examples that are common to date and time.

technet.microsoft.com