All,
Do we have any functions to convert seconds to HH:MM:SS format. I generally do it in database itself. This time looking for something in Datastage. Can we do it without Routines.
Seconds- 100
HH:MM:SS-00:01:40
Seconds- 10410
HH:MM:SS- 02:53:30
Thanks..
Seconds to HH:MM:SS
Moderators: chulett, rschirm, roy
TimeOffsetBySeconds parallel transform function converts seconds to HH:MM:SS format, provided basetime is set to midnight.
Code: Select all
TimeOffsetBySeconds("00:00:00", second_offset)
e.g. TimeOffsetBySeconds("00:00:00", 10410) = 02:53:30