DB2 Version 10.1 for Linux, UNIX, and Windows

LAST_DAY scalar function

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


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

The schema is SYSIBM.

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

Example 1: 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.
Example 2: 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'.