sqldatetime overflow exception

Question

SQL DATETIME OVERFLOW EXCEPTION?

Iftikar Hussain · Answer

you can validate either in your aspx or in sql as shown you earlier. Regards Iftikar

Sanjeeb Lenka · Answer

can you provide your sample code

Iftikar Hussain · Answer

Hi The SQL Datetime range is 1/1/1753 12:00:00 AM to 12/31/9999 11:59:59 PM You can validate datetime before inserting into db as like below DECLARE @Date VarChar(20)='01/01/1753 12:00:00' If Not IsDate(@Date) = 1 print 'Invalid date' ELSE print 'Valid' Regards Iftikar

MANEESH AN · Answer

I WANT TO DISPLAY FROM DATE AND TO DATE IN TEXTBOX BY USING DATETIME.BUT EXCEPTION OCCURED SQLDATETIME OVERFLOW EXCEPTION

Sanjeeb Lenka · Answer

plz provide more details with code so we can able to solve your problem