Convert datetime

• Krasavita

  SSC-Insane

  Points: 23138

  More actions

  August 25, 2011 at 10:13 am

  #243746

  I am getting error for this:

  'CONVERT(datetime, '20101001', 112)', 'CONVERT(datetime, '20101231', 112)')

  Can someone please let me know what is wrong in this convert.

  Thank you

• bisht.kuldeep

  SSC Enthusiast

  Points: 194

  More actions

  August 25, 2011 at 10:45 am

  #1373343

  Use Following

  select CONVERT(datetime, '20101001', 112), CONVERT(datetime, '20101231', 112)

  Or For Dynamic

  exec ('select CONVERT(datetime, ''20101001'', 112), CONVERT(datetime, ''20101231'', 112)')

  Thanks

  Kuldeep

  Kuldeep Bisht
  Simplion Technologies
  http://mssqlguide.kuldeepbisht.com

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  August 25, 2011 at 11:11 am

  #1373369

  bisht.kuldeep has it correct. you don't need the extra quotes in there, which cause a syntax error.