87.You want to display the date for the first Mon day of the next month and
issue the following command:
select 1 no from dual;
SQL>SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE),'MON'),'dd "is the first Monday for" fmmonth rrrr') FROM DUAL;
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 fm and double quotation marks should not be used in the format string.
答案:A
解析:这道题说的是显示下个月的第一个星期一
SQL> SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE),'MON'),'dd "is the first Monday for" fmmonth rrrr')
2 FROM DUAL;
TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE),'MON'),'DD
---------------------------------------------
04 is the first Monday for april 2016
--执行成功了
LAST_DAY(SYSDATE)指的是当月最后一天
NEXT_DAY(LAST_DAY(SYSDATE),'MON') 指的是从最后一天开始(不算该日期)第一个星期一
fmmonth :删除开头和结尾的空格
rrrr:完整的四位取整年份,其值取决于当前的年份
issue the following command:
select 1 no from dual;
SQL>SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE),'MON'),'dd "is the first Monday for" fmmonth rrrr') FROM DUAL;
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 fm and double quotation marks should not be used in the format string.
答案:A
解析:这道题说的是显示下个月的第一个星期一
SQL> SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE),'MON'),'dd "is the first Monday for" fmmonth rrrr')
2 FROM DUAL;
TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE),'MON'),'DD
---------------------------------------------
04 is the first Monday for april 2016
--执行成功了
LAST_DAY(SYSDATE)指的是当月最后一天
NEXT_DAY(LAST_DAY(SYSDATE),'MON') 指的是从最后一天开始(不算该日期)第一个星期一
fmmonth :删除开头和结尾的空格
rrrr:完整的四位取整年份,其值取决于当前的年份