Converting from DB2 time to DS time

patonp · Post by **patonp** » Thu Apr 19, 2007 10:11 am

I'm receiving data in a db2 extract where the time is represented by an integer based on the number of milliseconds that have elapsed since midnight. I'd like to convert this to a standard time format (i.e. HH:MM:SS.TTT). I realize that I can write my own routine to do this, but I'm hoping that there might be some out-of-the-box functionality in DS that does the conversion for me.

Any suggestions?

BTW - although I've classified this as a Parallel job type, I'm open to options on either canvas...

Cheers,

Peter

DSguru2B · Post by **DSguru2B** » Thu Apr 19, 2007 12:30 pm

Use TimeFromMidnightSeconds() function to get the time. But this function requires seconds since midnight and not milliseconds, so you will have to divide you will have to divide the number by 60 to get seconds. So you decide, can you live with getting time upto seconds or not.

rafik2k · Post by **rafik2k** » Thu Apr 19, 2007 12:42 pm

DSguru2B ,
Since Peter is already getting time in milliseconds,
I think he needs to multiply with it to get seconds, not divide.

DSguru2B · Post by **DSguru2B** » Thu Apr 19, 2007 12:45 pm

Really, think again

patonp · Post by **patonp** » Thu Apr 19, 2007 2:42 pm

Thanks for the suggestion!