DATE Data Type in SQL Server 2008

DATE is new data type that has been introduced in SQL Server 2008.It stores only date part.

DECLARE @DT DATE
SET @DT = '2012-01-13'
SELECT @DT AS 'Date'

That’s It.
Enjoy Learning.