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
Converting from DB2 time to DS time
Moderators: chulett, rschirm, roy
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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.