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?

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.
SELECT TO_CHAR(‘ll-oct-2007’. ‘miDdspth “of Month. Year’) FROM DUAL:

B.
SELECT TO_CHAR(TO_DATE(‘ll-oct-2007’X ‘miDdspth of month, year’) FROM DUAL;

C.
SELECT TO_CHAR(TO_DATE(‘ll-oct-2007’), ‘miDdthsp “of* Month. Year’) FROM DUAL;

D.
SELECT TO_DATE(TO_CHAR(‘ll-oct-20077fiiiDdspth “of” Month. Year’)) FROM DUAL:



Leave a Reply 5

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


Argha

Argha

Answer : SELECT TO_CHAR(TO_DATE(’11-oct-2007′), ‘Ddthsp “of” Month , Year’) FROM DUAL

Argha

Argha

SELECT TO_CHAR(TO_DATE(’11-oct-2007′), ‘fmDdthsp “of” Month , Year’) FROM DUAL

Eamon

Eamon

@Argha, you are correct. Thanks

ahmed

ahmed

select to_char (To_Date(’11-oct-2007′), ‘fmDdspth “of” month Year fmHH:MI:SS AM’)

More Tips

More Tips

Hello, of course this post is in fact nice and I have learned lot of things from it on the topic of blogging. thanks.|