OCP-1Z0-051 第89题 日期格式及转换

一、原题

You need to display the date 11-oct-2007 in words as 'Eleventh of October, Two Thousand Seven'.
Which SQL statement would give the required result?
A. SELECT TO_CHAR('11-oct-2007', 'fmDdspth "of" Month, Year')
        FROM DUAL;
B. SELECT TO_CHAR(TO_DATE('11-oct-2007'), 'fmDdspth of month, year')
        FROM DUAL;
C. SELECT TO_CHAR(TO_DATE('11-oct-2007'), 'fmDdthsp "of" Month, Year')
        FROM DUAL;
D. SELECT TO_DATE(TO_CHAR('11-oct-2007','fmDdspth ''of'' Month, Year'))
        FROM DUAL;

答案：C

二、题目翻译

需要把11-oct-2007显示为Eleventh of October, Two Thousand Seven
下面哪个SQL能得出所需的结果?

三、题目解析

A选项不正确，'11-oct-2007'本来就是个字符串，还用to_char转换就不对了。
B选项不正确，日期格式不对，如果不属于转换日期格式标识符需要使用双引号，如"of"
C选项正确。
D选项不正确，语法不对，和A类似，本来就是字符串，还转。

       日期格式的详细用法，详见：
               http://blog.csdn.net/holly2008/article/details/25213993