Retrieve the last day of the month for a specified date.
| SELECT LAST_DAY(“2017-06-20”); |
The LAST_DAY() function retrieves the final day of the month for a specified date.
| LAST_DAY(date) |
|
Parameter |
Description |
|
date |
Mandatory. The date from which to retrieve the last day of the month. |
|
Works in: |
From MySQL version 4.0 |
Get the last day of the month from the specified date.
| SELECT LAST_DAY(“2017-02-10 09:34:00”); |