Getting SqlDateTime overflow. exception in 2008

Posted by Shoab.shah under Sql Server on 5/12/2011 | Points: 10 | Views : 7651 | Status : [Member] | Replies : 1
Hello all,
am passing default dates (startdate & enddate) to an sp as ('1/1/1753 12:00:00 AM' & '12/31/9999 12:00:00 AM').

This was working fine in 2005, but am getting "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM" exception in 2008.

And the twist is such that when i run the sp from Management studio it works fine but on the live server through website it gives error.

thanks in advance




Responses

Posted by: Robin_ahuja2008 on: 6/16/2011 [Member] Starter | Points: 25

Up
0
Down
Please check the link
http://social.msdn.microsoft.com/forums/en-US/adodotnetdataproviders/thread/1426459e-9d0a-4cf0-a1ef-55535e06c6ef

Regards,
Robin Ahuja

Shoab.shah, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response