Convert Seconds in HH:MM:SS format using HANA SQL

select
“FullSeconds”
,TO_INT(“FullSeconds” / 3600) as “TotalHours”
,TO_INT(“FullSeconds” / 60) as “TotalMintues”
,”FullSeconds” as “TotalSeconds”
,TO_INT(“FullSeconds” / 3600) as “Hours”
,TO_INT(MOD(“FullSeconds” , 3600) / 60) as “Mintues”
,MOD(MOD(MOD(“FullSeconds” , 3600) , 60), 60) as “Seconds”
,concat(
concat(
CONCAT(TO_CHAR( TO_INT(“FullSeconds” / 3600)), ‘:’) ,
CONCAT(TO_CHAR( TO_INT(MOD(“FullSeconds” , 3600) / 60)),’:’)
), TO_CHAR(MOD(MOD(MOD(“FullSeconds” , 3600) , 60), 60))) as “TimeFormat”
from ( select 3666 as “FullSeconds” from dummy )



Serkan AKKAVAK
Computer Engineer
ABAP Developer & SAP S/4 HANA Logistics Team Lead
Contact : serkurumsal@yandex.com