LAST_DAY 함수

설명

LAST_DAY 함수는 인자로 지정된 DATE 값에서 해당 월의 마지막 날짜 값을 DATE 타입으로 반환한다.

구문

LAST_DAY ( date_argument )

 

date_argument :

• date

NULL

예제

--it returns last day of the momth in DATE type

SELECT LAST_DAY(DATE '1980-02-01'), LAST_DAY(DATE '2010-02-01');

  last_day(date '1980-02-01')   last_day(date '2010-02-01')

============================================================

  02/28/1980                    02/28/2010

 

--it returns last day of the momth when explicitly casted to DATE type

SELECT LAST_DAY(CAST (SYS_TIMESTAMP AS DATE)), LAST_DAY(CAST (SYS_DATETIME AS DATE));

  last_day( cast( SYS_TIMESTAMP  as date))   last_day( cast( SYS_DATETIME  as date))

================================================================================

  02/28/2010                                 02/28/2010