Oracle To_char format values

C:\Users\XXX>Sqlplus/  asSysdbasql*Plus:release10.2.0.5.0 -Production onSunday August -  the:Wuyi: the  .Copyright (c)1982, ., Oracle. Allrights Reserved. Connect to: OracleDatabase10g Enterprise Edition Release10.2.0.5.0 -64bitProduction withThe partitioning, OLAP, Data Mining and RealApplication Testing Optionssys@XXX> SelectTo_char ('0.123','FM999999999990.00'),0.123  fromdual; To_char ('0.123',0.123---------------- ----------0.12.123SYS@XXX> SelectTo_char ('0.125','FM999999999990.00'),0.125  fromdual; To_char ('0.125',0.125---------------- ----------0.13. the

The results of its implementation are as follows:

① its 9 representative: If the number is present, the number is displayed, the space does not exist;

② its 0 representative: If there is a number, the number is displayed, the non-existent is 0, that is, the placeholder;

③ its FM representative: Delete if it is caused by 9 of the space, then delete it;

④ rounded: 0.125 became 0.13 did not know people noticed no. If you do not round, you need to trunc under;

Oracle To_char format values