DSXchange

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

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.

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

Really, think again

Thanks for the suggestion!