Geeks With Blogs
Sathya Narayanan Srinivasan .NET Developer

Adding a value to a 'datetime' column caused overflow.

Came across this error today. So thought of posting the same.
Whenever you try to do a dateadd like thisĀ 

dateadd(mm,12,datefield)

you might face this error if the value in your records in the datefield is not a valid date or
if u add some months or date to this value and the output of that will exceed the date range

In my case i was just thinking what would be the error here.
But unfortunately there was some data in the table which was there with the value
(Ex:date of joining column)

1-1-9999

So my sql statement has tried to add 12 months to this and it had caused this error.

Posted on Friday, April 23, 2010 12:32 AM | Back to top


Comments on this post: Adding a value to a 'datetime' column caused overflow.

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © sathya | Powered by: GeeksWithBlogs.net