DB2 timestamp format

• Charlene Moore

  SSC Enthusiast

  Points: 146

  More actions

  May 18, 2006 at 6:28 am

  #68222

  Hi,

  I have been asked to convert a DB2 TIMESTAMP (ISO FORMAT) to YYYY-MM-DD hh:mm:ss.nnn.  I have tried several things but with no successful.  Any assistance will be greatly appreciated.

  Charlene

• Mark Harr

  SSCrazy Eights

  Points: 9921

  More actions

  May 19, 2006 at 6:45 am

  #638956

  In the past when I've had todo this, I loaded the DB2 Timestamp column into a varchar column, then had a computed column that converted the text to a datetime.  This column would be a long series of substring, left, and/or mid functions to extract each part of the date and time from the character string.  I am sorry, but I do not have that code handy to paste here, but I hope this will at least start you on the way.

  Hope this helps

  
  
  Mark

• Charlene Moore

  SSC Enthusiast

  Points: 146

  More actions

  May 19, 2006 at 6:59 am

  #638961

  Thanks Mark!  This is helpful!