Oracle
1Z0-082 · Question #34
You execute this query: SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), MON'), dd "Monday for" fmMonth rrrr') What is the result?
The correct answer is B. It returns the date for the first Monday of the next month. See the full explanation below for the reasoning.
SQL and PL/SQL
Question
You execute this query:
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), MON'), dd "Monday for" fmMonth rrrr') What is the result?
Options
- AIt executes successfully but does not return any result
- BIt returns the date for the first Monday of the next month
- CIt generates an error
- DIt returns the date for the last Monday of the current month
How the community answered
(21 responses)- A5% (1)
- B81% (17)
- C10% (2)
- D5% (1)
Topics
#date functions#NEXT_DAY#LAST_DAY#TO_CHAR
Community Discussion
No community discussion yet for this question.