89.You need to display the date 11-oct-2007 in words as 'Eleventh of October, Two Thousand Seven'.

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
解析：
A:错误，这里Month，fmDdspth这些都是针对日期类型的格式，而'11-oct-2007'是字符
B:错误，of不是格式参数，不能直接使用
C:正确，
Year：年份全拼，首字母大写
Month：月份的全拼，首字母大写，右端补齐空格，总长9个字符
fmDdthsp：这个是几部分组成
fm:修饰符是去掉多余的空格和0
Dd:本月第几天，和sp配合后，由于第一个是大写D，所以首字母大写，如果是DD，那么全部大写
th:后缀th
sp:数字的拼写形式


SQL> SELECT TO_CHAR(TO_DATE('11-oct-2007'), 'fmDdthsp "of" Month, Year') FROM DUAL;


TO_CHAR(TO_DATE('11-OCT-2007'),'FMDDTHS
---------------------------------------
Eleventh of October, Two Thousand Seven
D:错误，和A选项错误问题一样