Difference between DateTime and SmallDateTime in SQL Server

datetime vs smalldatetime sql server

In this video we will discuss the difference between DateTime and SmallDateTime in SQL Server

Attribute SmallDateTime DateTime
Date Range January 1, 1900, through June 6, 2079 January 1, 1753, through December 31, 9999
Time Range 00:00:00 through 23:59:59.997 00:00:00 through 23:59:59
Accuracy 1 Minute 3.33 Milli-seconds
Size 4 Bytes 8 Bytes
Default value 1900-01-01 00:00:00 1900-01-01 00:00:00

Link for all dot net and sql server video tutorial playlists
https://www.youtube.com/user/kudvenkat/playlists?sort=dd&view=1

Link for slides, code samples and text version of the video
http://csharp-video-tutorials.blogspot.com/2015/10/difference-between-datetime-and.html