Conversion failed when converting datetime from character string.

• Fraggle-805517

  SSCrazy Eights

  Points: 8907

  More actions

  September 22, 2010 at 6:47 am

  #140821

  Hello everyone.

  So I have a bit of quandry here. I have 3 seperate database servers. Each has the same phsical and software set. All or running 2005 Standard, 64 bit sql server, and 2003 windows server. SP3

  Across all 3 servers last night we had a massive failure of client jobs. Each has the following error:

  Conversion failed when converting datetime from character string.

  Now, here are things to consider.

  1) These servers have been running without issues for atleast 6 months

  2) there were absolutely NO changes to the code in the last 3 months

  3) I came in this morning and all of the jobs that failed with this error ran without issues. Again, not a single change that I can see or find.

  Does anyone have any thoughts on what might be gone on here. I have seen this once before in our test environement where I had to change the following code:

  SELECT *

  FROM Orders as O

  WHERE O.OrderDate BETWEEN '1/1/2010' AND '1/31/2010'

  to this:

  DECLARE @StartDate DATETIME

• Fraggle-805517

  SSCrazy Eights

  Points: 8907

  More actions

  September 22, 2010 at 7:17 am

  #1225559

  Not sure how, but I double posted. Please use this link for the post.

  http://www.sqlservercentral.com/Forums/Topic991105-149-1.aspx