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
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
You need to display the date 11-Oct-2007 in words as ‘Eleventh of October, Two ThousandSeven’. Which SQL statement would
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!