LAST_DAY SYNTAX: LAST_DAY(d) PURPOSE: Returns the date of the last day of the month that contains d. You
might use this function to determine how many days are left in the
current month. EXAMPLES: SELECT SYSDATE, LAST_DAY(SYSDATE) "Last",
LAST_DAY(SYSDATE) - SYSDATE "Days Left"
FROM DUAL SYSDATE Last Days Left --------- --------- ---------
18-NOV-92 30-NOV-92 12 SELECT TO_CHAR(ADD_MONTHS(LAST_DAY(hiredate),5),
'DD-MON-YYYY') "Five months"
FROM emp
WHERE ename = 'MARTIN' Five months
-----------
28-FEB-1992
might use this function to determine how many days are left in the
current month. EXAMPLES: SELECT SYSDATE, LAST_DAY(SYSDATE) "Last",
LAST_DAY(SYSDATE) - SYSDATE "Days Left"
FROM DUAL SYSDATE Last Days Left --------- --------- ---------
18-NOV-92 30-NOV-92 12 SELECT TO_CHAR(ADD_MONTHS(LAST_DAY(hiredate),5),
'DD-MON-YYYY') "Five months"
FROM emp
WHERE ename = 'MARTIN' Five months
-----------
28-FEB-1992
解决方案 »
- ORA-00604: 递归 SQL 层 1 出现错误,ORA-06553:PLS-213: standard包打不开
- Georaster中如何Load jpg类型的图片
- 视图+DBLINK 求解!
- 求一解决方法!~~~~~~~~~~~~~
- 请高手指点迷经:怎样用SQL向Long Raw字段插入数据
- Oracle数据库中的系统表包括哪些?挑最重要的给我讲讲
- ORA-01536
- 关于自动计算的问题,请指点
- 大家好!谁能帮我找个oracle 8.1.6 client for windows2000.
- 如何在oracle10g 打开4G以上内存!!!
- HP UX环境下ProC程序的编译问题
- 在触发器中如何实现回滚或取消操作
select last_day(sysdate-60)+1 from dual;
----------
01-5月 -03
------------------------------
2003-5-1