Smalldatetime - TSQL Tutorial

On Transact SQL language the smalldatetime is part of date and time data types and define a date that is combined with a time of day.

Smalldatetime syntax:

smalldatetime

PropertyValue
Range1900-01-01 through 2079-06-06
Length19 maximum
Storage size4 bytes
CalendarGregorian

Smalldatetime example:

USE model;
GO
DECLARE @smalldatetime smalldatetime = '2014-08-21 11:03:17';
DECLARE @date date = @smalldatetime
SELECT @smalldatetime AS 'Smalldatetime', @date AS 'Date';
GO

SmalldatetimeDate
2014-08-21 11:03:002014-08-21