返回数说广场
0
哪条sql语句可以将时间11-Oct-2007转换成’Eleventh of October, Two Thousand Seven’输出。答案:B。
A SELECT TO_DATE(TO_CHAR('11-oct-2007','fmDspth "of" Month, Year')) FROM DUAL;
B SELECT TO_CHAR(TO_DATE('11-oct-2007'),'fmDspth "of" Month, Year') FROM DUAL;
C SELECT TO_CHAR(TO_DATE('11-oct-2007'),'fmDspth of Month, Year') FROM DUAL;
D SELECT TO_CHAR('11-oct-2007','fmDspth "of" Month, Year') FROM DUAL;
0
0 120
分享
评论
热门数说


