Home » SQL & PL/SQL » SQL & PL/SQL » about using fm ???
about using fm ??? [message #218628] Fri, 09 February 2007 01:14 Go to next message
m_arafa
Messages: 36
Registered: June 2006
Member
hi,
in exam :-

Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of
March 2001 12:00:00 AM"?

A. SELECT
TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth
"of" Month YYYY fmHH:MI:SS AM') NEW_DATE
FROM dual;

B. SELECT
TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'Ddspth
"of" Month YYYY fmHH:MI:SS AM') NEW_DATE
HH:MI:SS AM') NEW _ DATE FROM dual;

C. SELECT
TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY
NEW _ DATE FROM dual;

D. SELECT
TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY), 'fmDdspth "of" Month YYYYfmtHH:HI:SS AM')

i want to answer this question and about using FM ????

thanks,
Re: about using fm ??? [message #218629 is a reply to message #218628] Fri, 09 February 2007 01:18 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
open sqlplus and TRY it.
That will teach you much more than anyone telling you the answer.
Previous Topic: Finding IDs which have different CODE
Next Topic: How to get a random number...
Goto Forum:
  


Current Time: Tue May 30 00:33:15 CDT 2017

Total time taken to generate the page: 0.20654 seconds