Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2011

    Unanswered: how to solve this problem ?

    Conversion failed when converting datetime from character string.
    i m getting this error while inserting values in the DB from my application
    i have done insertion before too , but i never receive this strange error but when
    i insert the same thing manually then i didn't get this error
    how to solve this error
    the format i used is also yyyy-mm-dd
    then how to solve this error?????????

  2. #2
    Join Date
    Nov 2004
    Provided Answers: 4
    I have stopped relying on good faith in MSSQL to do string to DATE conversions. Do an explicit CONVERT
    SELECT CONVERT(DATETIME, '2011-12-31', 120)
    If it has always worked until now, your application may have fed it some flawed data. Check if the format is really YYYY-MM-DD. Print the string you pass to MSSQL (log file, screen, ...), to be 100% sure.
    With kind regards . . . . . SQL Server 2000/2005/2012

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts