Oracle
1Z0-061 · Question #190
You need to calculate the number of days from 1st January 2007 till date . Dates are stored in the default format of dd-mon-rr. Which two SQL statements would give the required output? (Choose two.)
The correct answer is B. SELECT SYSDATE - TOJDATE(X)1/JANUARY/2007") FROM DUAL: C. SELECT SYSDATE - TOJDATE('01-JANUARY-2007') FROM DUAL. See the full explanation below for the reasoning.
Question
You need to calculate the number of days from 1st January 2007 till date . Dates are stored in the default format of dd-mon-rr. Which two SQL statements would give the required output? (Choose two.)
Options
- ASELECT SYSDATE - '01-JAN-2007' FROM DUAL:
- BSELECT SYSDATE - TOJDATE(X)1/JANUARY/2007") FROM DUAL:
- CSELECT SYSDATE - TOJDATE('01-JANUARY-2007') FROM DUAL:
- DSELECT TO_CHAR(SYSDATE. 'DD-MON-YYYY') - '01-JAN-2007' FROM DUAL:
- ESELECT TO_DATE(SYSDATE. *DD/MONTH/YYYY') - '01/JANUARY/2007' FROM DUAL:
How the community answered
(45 responses)- A13% (6)
- B78% (35)
- D2% (1)
- E7% (3)
Community Discussion
No community discussion yet for this question.