where condition is drpDate in sql 2005

Question

I Found an error when the time of filling in grid.parameter passing as datetimein sql 2005.i dont know how to convert datetime to string and remaining parameters passing as string.give example with code... SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

Ravi Shekhar · Answer

Hi check http://www.blackwasp.co.uk/SQLDateTimeFormats.aspx I am suggesting you to use 101 code .

Iftikar Hussain · Answer

Hi Please validate the input date before inserting into sql. Regards Iftikar

Sunny Sharma · Answer

Hello Manish I assume you're doing so in C#. Convert the DateTime value to string like this: str dateStr = myDateTime.ToString(yyyy-MM-dd); Hope it helps. Cheers!