LAST_DAY

On this page

Finds the month of the input date, and then returns a date object containing the last day of that month.

Syntax

LAST_DAY (dateobj)

Arguments

dateobj: a valid date, datetime, or parsable date string

Return Type

Date object. If dateobj is not a valid date, returns NULL.

Examples

SQL

SELECT LAST_DAY('2019-01-01 05:06');

+------------------------------+
| LAST_DAY('2019-01-01 05:06') |
+------------------------------+
| 2019-01-31                   |
+------------------------------+

Related Topics

Data Types

Last modified: May 31, 2023

Was this article helpful?