select to_char(1.5678,'99.99') from dual
输出:1.57
select to_char(1.5,'00.00') from dual
输出:01.50
select to_char(1.5678,'99.99') from dual
输出:1.57
select to_char(1.5,'00.00') from dual
输出:01.50
转载于:https://www.cnblogs.com/modou/articles/2601088.html