datetime conversion error

• Eshika

  SSCrazy

  Points: 2046

  More actions

  October 28, 2010 at 9:21 am

  #228454

  Hello all I have data in the format '6/9/2006

  and need to load it as datetme can any one please help me as iam not ale to convert it . I have tried 100 ways ... but still I am not able to it gives the following error

  Conversion failed when converting date and/or time from character string.

  your response is a life saver ..

• ColdCoffee

  SSC-Dedicated

  Points: 39972

  More actions

  October 28, 2010 at 9:26 am

  #1243642

  Dint you try cast and convert functions?

  select cast ( '6/9/2006' as datetime)

  select convert( datetime,'6/9/2006' )