Oracle
1Z0-071 · Question #98
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?
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #98. The question stem and answer options stay visible for context.
Using Conversion Functions and Conditional Expressions
Question
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?
Options
- ASELECT TO_CHAR (TO_DATE ('11-oct-2007'), `fmDdthsp "of" Month, Year') FROM DUAL
- BSELECT TO_CHAR (
11-oct-2007',fmDdspth "of" Month, Year') FROM DUAL - CSELECT TO_CHAR (TO_DATE (
11-oct-2007'),fmDdspth "of" month, Year') FROM DUAL - DSELECT TO_DATE (TO_CHAR ('11-oct-2007'), `fmDdspth "of" Month, Year')) FROM DUAL
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#TO_CHAR#TO_DATE#date format model#spell out date