DB2 Version 9.7 for Linux, UNIX, and Windows

LAST_DAY scalar function


>>-LAST_DAY--(--expression--)----------------------------------><

The schema is SYSIBM.

The LAST_DAY scalar function returns a datetime value that represents the last day of the month of the argument.

expression: An expression that specifies the starting date. The expression must return a value of one of the following built-in data types: a DATE or a TIMESTAMP.

The result of the function has the same data type as expression, unless expression is a string, in which case the result data type is DATE. The result can be null; if the value of date-expression is null, the result is the null value.

Any hours, minutes, seconds or fractional seconds information included in expression is not changed by the function.

Examples

Set the host variable END_OF_MONTH with the last day of the current month.
```
     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 the host variable END_OF_MONTH with the last day of the month in EUR format for the given date.
```
     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'.