[an error occurred while processing this directive]

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)

 

 

                         

[an error occurred while processing this directive]