不说废话,贴代码: CREATE OR REPLACE FUNCTION to_time(sec IN NUMBER) RETURN VARCHAR2 IS /*把秒转成时分秒格式 auth lzpong 201/09/16 */ BEGIN ))), ,); EXCEPTION WHEN OTHERS THEN RETURN '0:00:00'; END to_time; CREATE OR REPLACE FUNCTION isnumeric(str IN VARCHAR2) RETURN
// 时间转为毫秒 timeToSec(time) { var hour = time.split('[0] var min = time.split('[1] var sec = time.split('[2] var s = Number(hour * 3600) + Number(min * 60) + Number(sec) return s * 1000 } // 将秒转化成时分秒 secTotime(s) { var t if(s > -1){ var hour = Math.flo
1>函数转换 select nvl2(translate(a.data, '\1234567890.', '\'), null, a.data) n, a.data from rpt_detail a; 2>自定义函数 create or replace function isNumber(p_in varchar2) return boolean as i number; begin i:=to_number(p_in); return true; exception when others
用法如下:get_capital_money(Currency, Money) Currency: 货币或货币描述,将放在英文大写的前面: Money:金额.支持两位小数点.如果需要更多的小数点,请自行修改. create or replace function GET_CAPITAL_MONEY ( P_currency varchar2, P_money number) return varchar2 IS type DIME is table of varchar2(20) index b