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

1.SQL> SELECT TO_CHAR (to_Date('20130801','yyyymmdd'), 'Month Day YYYY') AS NORMAL_DATE FROM dual;

 

NORMAL_DATE

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

August    Thursday  2013

2.SQL> SELECT TO_CHAR (to_Date('20130801','yyyymmdd'), 'FMMonth Day YYYY') AS ONE_FM FROM dual;

 

ONE_FM

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

August Thursday 2013

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之后的字符串要去掉空格。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29016439/viewspace-767617/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29016439/viewspace-767617/