ROUND(125.72,2) RAND(3)
MIN({^1976/12/16},{^1973/12/25}) ROUND(129.728,0) ROUND(129.728,-1) ROUND(-29.28,1) RAND() 2、字符函数\ LEN('good! ') LTRIM('good! ') RIGHT('good!',2) LEN(SPAC(10)) LEN(' 您好!') LTRIM(' 您好!') RIGHT('您好!',2) REPL('您好!',5) TRIM('good!') LEFT('good!',2) SUBS('good!',2,2) REPL('good!',5) TRIM(' 您好!') LEFT('您好!',2)
SUBS('您好!',3,2) REPL('=',5) \日期和时间函数\ TIME() DATE() YEAR(DATE()) YEAR({^1997/12/21}) MONTH(DATE()) MONTH({^1997/12/21}) DAY(DATE()) DAY({^1997/12/21}) 4.转换函数\ VAL('128') STR(123.765,4) ASC('a') CHR(92) STR(128,3) STR(129.7,5,1) STR(295.7) STR(123.765,6) ASC('A') ASC('BACK')
CHR(65) CHR(7)
UPPER('Good') LOWER('GOOD')
