Joseph Jones
asked on
Storing dates less than year 1900
Hi
I have problem in storing dates less than year 1900 in sql server 2005. I get the following error message:
SqlDbType.SmallDateTime overflow. Value '01/22/1898 00:00:00' is out of range. Must be between 1/1/1900 12:00:00 AM and 6/6/2079 11:59:59 PM.
Can anybody help me to solve this problem,
Thanks
JOLEEJE
I have problem in storing dates less than year 1900 in sql server 2005. I get the following error message:
SqlDbType.SmallDateTime overflow. Value '01/22/1898 00:00:00' is out of range. Must be between 1/1/1900 12:00:00 AM and 6/6/2079 11:59:59 PM.
Can anybody help me to solve this problem,
Thanks
JOLEEJE
change your column to datetime
smalldatetime can only
datetime has a range of January 1, 1753, through December 31, 9999
and smalldatetime range is from January 1, 1900, through June 6, 2079
datetime has a range of January 1, 1753, through December 31, 9999
and smalldatetime range is from January 1, 1900, through June 6, 2079
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
THANKS,
CHEERS
CHEERS