SQLDATETIMEOVERFLOW

Question

SQL DATETIME OVERFLOW IN SQL2005 IN C#.NET.HOW CAN SOLVE? ERROR:SQLDATETIMEOVERFLOW.mUST BETWEEN 1/1/1753 12:00:00 AM AND 12/31/9999 11:59:59 PM.

Ravi Shekhar · Answer

use code 101 to convert date. syntax... select CONVERT(datetimeGETDATE()101) result 2013-07-06 13:56:11.830

Ravi Shekhar · Answer

Hi MANEESH  You have to use date time conversion.and share your date which you pass in your code.... Check below code!!! http://msdn.microsoft.com/en-us/library/ms187928.aspx regards Ravi