LAST_DAY feature introduction

Detail name	Value
Changelog Number	29983
Type	New Feature
Status	Resolved
Fix Versions	Exasol 2026.1.1
Resolution Date	2026-08-06

Background

Exasol provides scalar functions https://docs.exasol.com/db/latest/sql_references/functions/scalarfunctions.htm, including functions to manipulate date/time, strings, numeric, etc.

New Feature

New scalar function: LAST_DAY

This function returns the last day of the month for the provided DATE, TIMESTAMP, or TIMESTAMP WITH LOCAL TIME ZONE value. It also accepts strings that can be cast to the respective date/time types.

The return type is DATE.

Example

SELECT LAST_DAY(DATE '2003-01-02');

Result

LAST_DAY(DATE '2003-01-02')
2003-01-31

For more details, see LAST_DAY documentation in Scalar Functions (will be added when the feature is released).