SELECT
TO_CHAR(TRUNC(x/3600),'FM9900')||':'||
TO_CHAR(TRUNC(MOD(x,3600)/60),'FM00')||':'||
TO_CHAR(MOD(x,60),'FM00')FROM DUAL
oracle seconds to hh:mm:ss format
最新推荐文章于 2024-07-18 16:32:46 发布
SELECT
TO_CHAR(TRUNC(x/3600),'FM9900')||':'||
TO_CHAR(TRUNC(MOD(x,3600)/60),'FM00')||':'||
TO_CHAR(MOD(x,60),'FM00')FROM DUAL