SqlDateTime overflow

Question

Hi I am getting SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. this error while inserting data into DB. i give all things are correct only datatype and datetime sytax then also i am getting this error.

Sundar · Answer

Check the format of Date and Time while Inserting. Mostly there may the error. all the best !!!

Amit Gupta · Answer

It would be helpful if you share your stuff what you have done

Khan Abrar Ahmed · Answer

Hi check your input parameter if it is not nullable parameter then code will send defulat date like 01/01/0001. check while insertion what value you are getting in the parameter.