Post reply

DB2 timestamp format

  • 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

  • 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

  • May 19, 2006 at 6:59 am

    #638961

    Thanks Mark!  This is helpful! 

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply