, try to manually add data found not correct conversion into a new 1 day, can only become a new day, + 86400 is less than this number, will be swallowed

CodePudding user response:

Function has a problem in the process of storage, round - & gt; Trunc, a try,

CodePudding user response:

Is to describe the seconds into Chinese characters? Write too wordy, one line of code enough

 select trunc (100000/86400) | | to_char (trunc (sysdate) + 100000/86400, 'FM "day" hh24 "hour" mi "minutes" ss "seconds") from dual; 

CodePudding user response:

reference 1st floor lhdz_bj response:

function has a problem in the process of storage, round - & gt; Trunc, a try,

bosses, thanks a lot