Turn a number into time

[francofiorillo]

Hello.
I have an integer that tells me the seconds of an operation.
How can I transform this integer into hours, minutes, seconds in the format hh: mm: ss? Thanks
for example, in number 4500 it represents 1 hour and 15 minutes

[syedMohammed]

hi @francofiorillo 

try

interval(timestamp#(4500 , 's'), 'hh:mm:ss')

Output: 01:15:00

[MarcoWedel]

another option would be:

Interval(4500/86400,'hh:mm:ss')