datetime conversion

• rpatil22

  Ten Centuries

  Points: 1371

  More actions

  July 28, 2009 at 11:08 am

  #136615

  I need to convert following dates into datetime. consider year 2009

  Here is input

  20Jul 15:46:1

  22Jul 06:21:8

• Allister Reid

  SSCrazy

  Points: 2666

  More actions

  July 28, 2009 at 11:22 am

  #1031202

  The following code works for the examples you posted:

  DECLARE @Input TABLE ([Date] VARCHAR(14))

  INSERT INTO @Input

  SELECT '20Jul 15:46:1' UNION ALL

  SELECT '22Jul 06:21:8'

  SELECT CONVERT(DATETIME, SUBSTRING([Date],1,2) + ' ' + SUBSTRING([Date],3, LEN([Date]) - 2) + ' 2009') FROM @Input

• drew.allen

  SSC Guru

  Points: 76989

  More actions

  July 28, 2009 at 12:23 pm

  #1031237

  Another option SELECT Convert(Datetime, Replace('20Jul 15:46:1', ' ', '2009 '))

  Drew

  J. Drew Allen
  Business Intelligence Analyst
  Philadelphia, PA