What is the outcome?

You want to display the date for the first Monday of the next month and issue the following command:

What is the outcome?

You want to display the date for the first Monday of the next month and issue the following command:

What is the outcome?

A.
It executes successfully and returns the correct result.

B.
It executes successfully but does not return the correct result.

C.
It generates an error because TO_CHAR should be replaced with TO_DATE.

D.
It generates an error because rrrr should be replaced by rr in the format string.

E.
It generates an error because fm and double quotation marks should not be used in the format
string.

Explanation:



Leave a Reply 2

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


The Tuk

The Tuk

select sysdate from dual;
select to_char(next_day(last_day(sysdate),’mon’),’dd “is the first monday for” fmmonth rrrr’) from dual ;
SYSDATE
———
02-NOV-17

TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE),’MON’),’DD”ISTHEFIRSTMONDAYFOR”FM
——————————————————————–
04 is the first monday for december 2017