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

Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.
https://www.youtube.com/channel/UC7sEwIXM_YfAMyonQCrGfWA/?sub_confirmation=1

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