doubt on oracle question?

[manas ranjan mandal]

A family of 4 contains 2 sons who are born the following dates respectively February 1,2000 and April 18,2004
Assumption: Assume the DB is oracle and none of the default DB settings have been altered.
Which of the following queries will give us the exact number of days between the birth dates of the 2 sons?

1) select '01-02-2000'-'18/05/2004' from dual
2)select to_date('01-FEB-2000')-to_date('18-APR-2004') from dual
3)select to_date('01-FEB-2000','DD-MMM-YYYY')-to_date('18-APR-2004','DD-MMM-YYYY') from dual

[Campbell Ritchie]

It's obvious. No 4.
What do you think?
Did you read what I said about your previous post?

[manas ranjan mandal]

if i know the answer then why should i put it in this forum..

[Campbell Ritchie]

Originally posted by manas ranjan mandal:
if i know the answer then why should i put it in this forum..

Read these FAQs: ShowSomeEffort and DoYourOwnHomework.