Seconds to HH:MM:SS

[sam334]

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..

[rkashyap]

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

[qt_ky]

TimeFromMidnightSeconds
Returns the time given the number of seconds since midnight.

Note: All the built in functions are fairly well documented in the product guides and online help.

[sam334]

Thanks a lot. I was checking parallel dev guide.Seems like missed that part. Thanks again.