Mysql last day of month
The Tutorial illustrate an example from 'Mysql Last Day of Month'. To understand and grasp the example we run LAST_DAY(now( )) that return the last day of the month.
LAST_DAY(now( )) : The Query return the last day of the current month a s fieldname Last Day of Month.
Query:
mysql> SELECT DAY(LAST_DAY(now())as LastDayOfMonth; |
Output:-
+----------------+ | LastDayOfMonth | +----------------+ | 31 | +----------------+ 1 row in set (0.00 sec) |