Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    4

    Unanswered: Syntex Error converting datetime from character string

    HI
    WE ARE USING SQL SERVER7.0 WITH BASE PACK , SINCE YESTERDAY I M GETTING " SQL ERROR 241 : SYNTEX ERROR CONVERTING DATETIME FROM CHARACTER STRING" I HAVE TRIED WITH SP4 , BUT NOW IM GETTING " TIMED OUT ERROR IN MY APPLICATION" ANY SOLUTION

    NEED URGENT SOLUTION

    TIA

    DARA

  2. #2
    Join Date
    Oct 2003
    Location
    Switzerland
    Posts
    140
    Can you give us MUCH more details about the statement that is failing ?

  3. #3
    Join Date
    Oct 2003
    Posts
    4
    Originally posted by cvandemaele
    Can you give us MUCH more details about the statement that is failing ?

    Well when we are updating any row in a some tables , we are getting the error msg , we have checked on the microsoft site , according to them there is some problem with the base pack and the problem is resolved in the sp3 or later. we have had applied the SP4 alsobut the problem is same.

    thnk in advance

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    you might also want to find and show us the actual character string value that is causing the conversion error
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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