You need to display the date 11-Oct-2007 in words as ‘Eleventh of October, Two ThousandSeven’. 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;
You need to display the date 11-Oct-2007 in words as ‘Eleventh of October, Two ThousandSeven’. Which SQL statement would
-
- Site Admin
- Posts: 899559
- Joined: Mon Aug 02, 2021 8:13 am