The LAST_DAY scalar function returns a date that represents the last day of the month indicated by expression.
If expression is a character or graphic string, it must not be a CLOB or DBCLOB and its value must be a valid string representation of a date or timestamp. For the valid formats of string representations of dates and timestamps, see String representations of datetime values.
The result of the function is a date. If either argument can be null, the result can be null; if either argument is null, the result is the null value.
SET :END_OF_MONTH = LAST_DAY(CURRENT_DATE)
The host variable END_OF_MONTH is set with the value representing the end of the current month. If the current day is 2000-02-10, then END_OF_MONTH is set to 2000-02-29.
SET :END_OF_MONTH = CHAR(LAST_DAY('1965-07-07'), EUR)
The host variable END_OF_MONTH is set with the value '31.07.1965'.
SELECT LAST_DAY('2000-04-24') FROM SYSIBM.SYSDUMMY1
Returns '2000-04-30' which is the last day of April in 2000.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.