将数字转换为时间 [英] Convert number to time

问题描述

如何将数字1.33408564814814转换为时间32:01:05?

How to convert number 1.33408564814814 to time 32:01:05?

推荐答案

如果您实际上希望将结果作为字符串，则可以使用如下函数:

If you actually want the result as a character string, you could use a function like this:

set serveroutput on format wrapped;

declare
function days_to_time (p_days number) return varchar2
is
  d number := p_days;
  h integer;
  m integer;
  s integer;
begin
  h := trunc(d*24);
  d := d - h/24;
  m := trunc(d*24*60);
  d := d - m/24/60;
  s := round(d*24*60*60);
  return(h||':'||to_char(m,'FM00')||':'||TO_CHAR(s,'FM00'));
end;
begin
  dbms_output.put_line(days_to_time(1.33408564814814));
end;
/

anonymous block completed
32:01:05

这篇关于将数字转换为时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！