YOU need to display the date ll-oct-2007 in words as ‘E…

YOU need to display the date ll-oct-2007 in words as ‘Eleventh of October, Two Thousand Seven’.Which SQL statement would give the required result?

YOU need to display the date ll-oct-2007 in words as ‘Eleventh of October, Two Thousand Seven’.Which SQL statement would give the required result?

A.
Option A

B.
Option B

C.
Option C

D.
Option D

Explanation:
The ’11-oct-2007′ is a string not a date. We need to user the TO_DATE function and convert it to a date.



Leave a Reply 0

Your email address will not be published. Required fields are marked *