TO_CHAR中的FM格式(来源于newkid每日一题)

3.SQL> SELECT TO_CHAR (to_Date('20130801','yyyymmdd'), 'Month FMDay YYYY') AS ONE_FM FROM dual;

 

ONE_FM

-----------------------

August    Thursday 2013

4.SQL> SELECT TO_CHAR (to_Date('20130801','yyyymmdd'), 'Month Day FMYYYY') AS ONE_FM FROM dual;

 

ONE_FM

------------------------

August    Thursday  2013

5.SQL> SELECT TO_CHAR (to_Date('20130801','yyyymmdd'), 'FMMonth FMDay YYYY') AS TWO_FM FROM dual;

 

ONE_FM

---------------------

August Thursday  2013

总结; FM类似开关，仅作用于Month跟Day，第一个FM告诉Oracle后面的所有的字符串需要去掉空格，但假如又出现第二个，则第二个FM之后的字符串不去掉空格，再出现一个FM,第三个FM之后的字符串要去掉空格。