time:2015/04/21 1. string.format() function GetPreciseDecimal(nNum, n) if type(nNum) ~= "number" then return nNum; end n = n ; n = math.floor(n) local fmt = '%.' .. n .. 'f' local nRet = tonumber(string.format(fmt, nNum)) return nRet; end 后记:201
题目描述 Given two postive integers A and B, please calculate the maximum integer C that C*B≤A, and the real number D equal to A/B. 输入格式 Two integers A and B in one line separated by a space.(A,B>0) 输出格式 Output C in one line,followed by D in one line. D
If IsNull({DECL_INV_ITEM_I.DECLEAR_NO}) Or Trim({DECL_INV_ITEM_I.DECLEAR_NO}) = "" Then "0" Else CStr({DECL_INV_ITEM_I.EX_RATE},5,',') CSTR({number_field}, 0, ''),第一个是数字字段:第二个是保留的小数位,0是整数:第三个是千分位分隔字符.
math.random([n [,m]]) 用法:1.无参调用,产生[0, 1)之间的浮点随机数. 2.一个参数n,产生[1, n]之间的整数. 3.两个参数,产生[n, m]之间的整数. math.randomseed(n) 用法:接收一个整数n作为随即序列的种子. 例: math.randomseed(os.time()) , do local n = math.random() print(n) end , do math.randomseed(os.time()) local n = m
SQL> SELECT TO_CHAR(, '9990.00') A, TO_CHAR(5.8, '9990.00') B, TO_CHAR(., '9990.00') C FROM dual; A B C ---------------- ---------------- ---------------- 123.00 5.80 0.46 SQL> ‘9990.00’表示转换的数字的最大数,可根据自身表里面的number字段大小,进行调整.比如number(19,2)可变成 : ltrim(