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
| Property | Value |
|---|---|
| Range | 1900-01-01 through 2079-06-06 |
| Length | 19 maximum |
| Storage size | 4 bytes |
| Calendar | Gregorian |
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
| Smalldatetime | Date |
|---|---|
| 2014-08-21 11:03:00 | 2014-08-21 |