本文详细解释了如何使用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 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.
答案：（A）
解析：
D（X），有rrrr这种格式
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17013648/viewspace-1163099/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/17013648/viewspace-1163099/
扫一扫
8982
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
