locked
DateTime(localisation) and SQL problem... RRS feed

  • Question

  • User-945309190 posted

    Hi Folks,

    I am developing a web application and I am implementing localisation(english,spanish...). When I am trying to add an record to the SQL database., it adds successfully. Now, when I try to update the record I get an error about "arithmetic overflow error converting expression to data type datetime.". I have realised that the datatype parameters I am adding, cause this error.

    The code I am using is

    date = DateTime.Now.ToString("M/d/yyyy h:mm:ss tt");

    I have used other format, but they haave caused the "arithmetic..." when I an adding the record. The code aboves works when I am adding the record..but when I try to make an update I get the error.

    Can someone kindly assist me?.. I am using .NET 03

    Wednesday, August 30, 2006 12:51 PM

All replies

  • User-945309190 posted

    I found the solution to this problem. You can view  it  in the web forms forum.

    Thanks...

    Wednesday, August 30, 2006 9:21 PM