时间秒数转成时间格式

TO_CHAR(TO_TIMESTAMP(createtime),'YYYY-MM-DD HH24:MI:SS') AS strtime 

原文地址:https://www.cnblogs.com/Daniel-G/p/4555744.html