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.

Read syntax diagramSkip visual syntax diagramLAST_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'.