DIFFERENCES BETWEEN SMALLDATETIME AND DATETIME IN SQL SERVER 2005.

Similarities and Differences.

1.Storage size for smalldatetime is 4 bytes and storage size for datetime is 8 bytes.

2.Minimum value for small date time is Jan 1 , 1990 where as it is Jan 1 , 1753.

3.Maximum value for small date time is June 6 , 2079 where as it is 31 dec , 9999.

4. SmallDateTime is usually used when you dont need to store time of the day.

5.DateTime is used if the time of the day is needed and upto seconds accuracy is required.

6.In DateTime values are rounded to increments of .000 , .003 or .009 seconds.

7.In smalldatetime values are rounded upto nearest minutes.

8.Time accuracy for small datetime is upto a minute.

9.Time accuracy for datetime is 1-3 hunderdth of a second.

Pawan Kumar
Pawankkmr@hotmail.com

Advertisements