[20260430]转换秒到时分秒.txt

--//记录一个简单方法将秒转换为时分秒格式。

SCOTT@book01p> select to_char(to_date(86399,'sssss'),'hh24:mi:ss') c10 from dual;
C10
----------
23:59:59

SCOTT@book01p> select to_char(to_date(86401,'sssss'),'hh24:mi:ss') from dual;
select to_char(to_date(86401,'sssss'),'hh24:mi:ss') from dual
*
ERROR at line 1:
ORA-01853: seconds in day must be between 0 and 86399

--//最大86399.

--//顺便建立s2hms.sql脚本：
$ cat s2hms.sql
column "hh24:mi:ss" format a10
select to_char(to_date(&&1,'sssss'),'hh24:mi:ss') "hh24:mi:ss" from dual;

ITPub博客

[20260430]转换秒到时分秒.txt

最新文章