numtodsinterval(150, 'DAY') | would return '+000000150' |
numtodsinterval(1500, 'HOUR') | would return '+000000062' |
numtodsinterval(15000, 'MINUTE') | would return '+000000010' |
numtodsinterval(150000, 'SECOND') | would return '+000000001' |
1) 150 days = 150 days
2) 1500 Hours /24 = 62.5 days ==> 0000000062
3) 15000 minutes /(24*60) = 10.41 days ===> 000000010
4) 150000 second /(60*60*24) = 1.736 days ==>000000001
将以第二项为单位的第一个数换算成整数天