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.