1. Range of Dates
A DateTime can range from January 1, 1753 to December 31, 9999.
A SmallDateTime can range from January 1, 1900 to June 6, 2079.
2. Accuracy
DateTime is accurate to three-hundredths of a second.
SmallDateTime is accurate to one minute.
3. Size
DateTime takes up 8 bytes of storage space.
SmallDateTime takes up 4 bytes of storage space.
Armed with this knowledge, you may want to use SmallDateTime instead of DateTime if you only need to represent dates from January 1, 1900 to June 6, 2079 and you do not need accuracy below 1 minute. Why? Simple! Using SmallDateTime will reduce the amount of data your queries are pulling back. The size of each row will be a bit smaller.
A DateTime can range from January 1, 1753 to December 31, 9999.
A SmallDateTime can range from January 1, 1900 to June 6, 2079.
2. Accuracy
DateTime is accurate to three-hundredths of a second.
SmallDateTime is accurate to one minute.
3. Size
DateTime takes up 8 bytes of storage space.
SmallDateTime takes up 4 bytes of storage space.
Armed with this knowledge, you may want to use SmallDateTime instead of DateTime if you only need to represent dates from January 1, 1900 to June 6, 2079 and you do not need accuracy below 1 minute. Why? Simple! Using SmallDateTime will reduce the amount of data your queries are pulling back. The size of each row will be a bit smaller.
No comments:
Post a Comment