秒转换为天 时 分 秒

SQL> select to_char(numtodsinterval(3830,'second')) from dual;

TO_CHAR(NUMTODSINTERVAL(3830,'
------------------------------
+000000000 01:03:50.000000000 //3830秒相当1小时3分50秒

SQL> select to_char(numtodsinterval(3830245,'second')) from dual;

TO_CHAR(NUMTODSINTERVAL(383024
------------------------------
+000000044 07:57:25.000000000 //3830245秒相当于44天7小时57分25秒

转载于:https://www.cnblogs.com/pbwxx/p/9192201.html