SQL - Scalar functions - LAST_DAY

LAST_DAY

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

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

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'.