Date change format in SSIS

• jman76

  Hall of Fame

  Points: 3388

  More actions

  November 14, 2013 at 7:04 am

  #286238

  Hi

  I have a file i want to import into a database with the date format as: 20131113

  When the date has imported into the table, i would like the format as: 2013-11-13

  How can i achieve this in SSIS package.

• jman76

  Hall of Fame

  Points: 3388

  More actions

  November 14, 2013 at 7:28 am

  #1666371

  I actually found the solution to this on Google. Here is the solution:

  SUBSTRING([OrderReceived],1,4) + "-" + SUBSTRING([OrderReceived],5,2) + "-" + SUBSTRING([OrderReceieved],7,2)