Native cloud deployment on Azure is not available for this version of Exasol, but you can install Exasol as a Linux application on Azure instances. For more information, see Installation.

Native cloud deployment on Google Cloud is not available for this version of Exasol, but you can install Exasol as a Linux application on Google Cloud instances. For more information, see Installation.

LAST_DAY

Purpose

This function retrieves the last day of the month from DATE and TIMESTAMP values.

Syntax

day::=

Day

Usage notes

The function takes a single parameter which can be DATE, TIMESTAMP, or TIMESTAMP WITH LOCAL TIME ZONE.
The function returns the last calendar day of the month corresponding to the specified input value.

This function is supported in 2025.2.2 and in Exasol 2026.1.1 and later.

Example

Copy

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

Result:

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