CREATE OR REPLACE FUNCTION GET_SS2DATE(in_second number) RETURN varchar2
IS
/*====================================================================*/
/* FUNCTION : GET_SS2DATE
/* Description : 根据传递进来的NUMBER串,返回天/小时/分/秒格式
/* Parameters : in_second
/* Version : 1.0 --初始版本
/* Author : Feng
/* Create Date : 20110113
/*
/*====================================================================*/
rDate varchar2(4000);
BEGIN
-- select trunc(100000/86400)||'天'||trunc(mod(100000,86400)/3600)||'小时'||trunc(mod(100000,3600)/60)||'分'||mod(100000,60)||'秒' from dual
SELECT trunc(in_second/86400)||'天'
||trunc(mod(in_second,86400)/3600)||'小时'
||trunc(mod(in_second,3600)/60)||'分'
||trunc(mod(in_second,60))||'秒'
INTO rDate
FROM dual;
return rDate;
EXCEPTION
WHEN others THEN
raise_application_error(SQLCODE,SQLERRM);
END;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10356975/viewspace-714904/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10356975/viewspace-714904/