Date - TSQL Tutorial

On Transact SQL language the date is part of date and time data types and define a date on sql server.

Date syntax:

date

PropertyValue
Default string literal formatYYYY-MM-DD
Range0001-01-01 through 9999-12-31
Length10
Storage size3 bytes, fixed
CalendarGregorian

Date example:

USE model;
GO
DECLARE @date date= '08-21-14';
SELECT @date AS 'Date';
GO

Date
2014-08-21