DATETIME column must fall within the range of January 1, 1753, through December 31,
9999.
SMALLDATETIME column must fall within the range of January 1,
1900, through June 6, 2079.
Hence we can use Smalldatetime for most of our apps.
Ref:http://suryan72.blogspot.com/2008/08/date-time-vs-small-datetime-in-sql.html
No comments:
Post a Comment