一、原题
http://blog.csdn.net/holly2008/article/details/25213993
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
二、题目翻译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能得出所需的结果?
三、题目解析下面哪个SQL能得出所需的结果?
A选项不正确,'11-oct-2007'本来就是个字符串,还用to_char转换就不对了。
B选项不正确,日期格式不对,如果不属于转换日期格式标识符需要使用双引号,如"of"
C选项正确。
D选项不正确,语法不对,和A类似,本来就是字符串,还转。
日期格式的详细用法,详见:B选项不正确,日期格式不对,如果不属于转换日期格式标识符需要使用双引号,如"of"
C选项正确。
D选项不正确,语法不对,和A类似,本来就是字符串,还转。
http://blog.csdn.net/holly2008/article/details/25213993