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.

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

Link for slides, code samples and text version of the video

[saritasahu]

thank you venkat sir, u cleared my so many doubts.... n I watched ur most of the video Igot gud job coz of ur superb videos. I am very thankful to you sir.I hateoff u .

[sandipshelake]

Thank you Venkat Sir for tutorials.
sir please post Angularjs tutorials

[krzysztofs]

Thank you for educating community. You are the best teacher on the planet. Thank you for this SQL Server tutorial. I grew up thanks to this tutorial. God bless your work and your whole family !

[tiagosilva]

What's the difference between truncate or delete * from a table?

[jasjocka]

Thank you for your videos.I have not found a tutorial on 'cristal report in asp.net'. Are you able to record a video about it. Thanks a lot