Important
Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.
LAST_
On this page
The LAST_ function 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.dateobj is not a valid date, returns NULL.
Examples
SELECT LAST_DAY('2019-01-01 05:06');
+------------------------------+
| LAST_DAY('2019-01-01 05:06') |
+------------------------------+
| 2019-01-31 |
+------------------------------+Related Topics
Last modified: