Convert 6 character varchar to datetime

• george.reeder

  SSC Veteran

  Points: 233

  More actions

  May 16, 2008 at 6:36 am

  #380580

  How can I convert a 6 character string (varchar) 062006 to a datetime?

• JacekO

  SSCertifiable

  Points: 6610

  More actions

  May 16, 2008 at 1:07 pm

  #816691

  is it 06/20/2006 or 06/01/2006?

  One of those should work. They are primitive but as long as you can goarantee the input format to be always 6 chars then you should be fine

  DECLARE @StringDate CHAR(6)

  SET @StringDate = '062006'

  DECLARE @Date DATETIME

  SELECT CONVERT(DATETIME, LEFT(@StringDate,2) + '/' + SUBSTRING(@StringDate,3,2) + '/' + RIGHT(@StringDate,2), 1)

  DECLARE @StringDate CHAR(6)

  SET @StringDate = '062006'

  DECLARE @Date DATETIME

  SELECT CONVERT(DATETIME, LEFT(@StringDate,2) + '/01/' + RIGHT(@StringDate,4), 101)

  ---------------------------------------------
  [font="Verdana"]Nothing is impossible.
  It is just a matter of time and money.[/font]