Problems with a simple CAST statement

• Macphil

  SSC Veteran

  Points: 238

  More actions

  May 13, 2009 at 2:09 am

  #137729

  Why if I run the 1st of the following 2 statements do I get and error, when both are valid dates?

  SELECT CAST('1976-12-14T00:00:00+02:00' as datetime)

  SELECT CAST('1976-12-14T00:00:01' as datetime)

  The error: Conversion failed when converting datetime from character string

  Regards

  MacPhil

• Samuel Vella

  SSCrazy Eights

  Points: 8055

  More actions

  May 13, 2009 at 2:22 am

  #993492

  The first isn't a valid time string

  use this instead:

  SELECT dateadd(hh, 2, CAST('1976-12-14T00:00:00' as datetime))