please reference:CREATE FUNCTION char_right(inval DECIMAL(22,2)) RETURNS CHAR(23) &n...
显示全部please reference:
CREATE FUNCTION char_right(inval DECIMAL(22,2))
RETURNS CHAR(23)
RETURN RIGHT(CHAR('',20) CONCAT RTRIM(CHAR(BIGINT(inval))),20)
CONCAT '.'
CONCAT SUBSTR(DIGITS(inval),21,2);
收起