AWS Athena Convert Seconds to HH:mm:ss

If you are running Presto, which supports a time datatype, you can just do:

select time '00:00:00' + no_seconds * interval '1' second

… where no_seconds is the number of seconds you want to convert.

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top