SQL>SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE),'MON'),
'dd "is the first Monday for" fmmonth rrrr')
FROM DUAL;
What is the outcome?
你想显示下月的第一个周一的日期,分析下面的语句:
SQL>SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE),'MON'),
'dd "is the first Monday for" fmmonth rrrr')
FROM DUAL;
输出是什么:
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.解析:
LAST_DAY() ,返回参数所在月份的最后一天日期
NEXT_DAY(a1,a2) 返回自a1日起,下个a2星期所在日期
TO_CHAR()转换为字符串
实验的时候会报错:
select NEXT_DAY (sysdate, 'MONDAY ') FROM DUAL;
ORA-01846: 周中的日无效
是因为NLS_DATE_LANGUAGE 参数因为的:
修改为alter session set NLS_DATE_LANGUAGE = American;就可以了;
或者直接使用数字代表星期也可以:
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE),1),'dd "is the first Monday for" fmmonth rrrr') FROM DUAL;