Error While conveting date from csv file

• Shaun2012

  Hall of Fame

  Points: 3214

  More actions

  November 25, 2013 at 12:21 pm

  #286582

  Hi,

  I have column paid_date which has to be converted to time stamp and dump in oracle.

  I am using the dervied column but keep getting the error

  Derived column:

  (DT_DBTIMESTAMP)(SUBSTRING(paid_date,1,4) + "-" + SUBSTRING(paid_date,5,2) + "-" + SUBSTRING(paid_date,7,2) + " " + SUBSTRING(paid_date,11,9))

  Shaun

• Mark Eckeard

  Hall of Fame

  Points: 3462

  More actions

  November 26, 2013 at 6:03 am

  #1669108

  Try converting paid_date to varchar before using substring. Something like this:

  select SUBSTRING(convert(varchar(25), paid_date),1,4) + '-' + SUBSTRING(convert(varchar(25), paid_date),5,2) + '-' + SUBSTRING(convert(varchar(25), paid_date),7,2) + ' ' + SUBSTRING(convert(varchar(25), paid_date),11,9)

  Mark

• Shaun2012

  Hall of Fame

  Points: 3214

  More actions

  November 26, 2013 at 7:43 am

  #1669155

  its working now... thanks mark..