Syntax error Select last day of current year in MySQL?

Select last day of current year in MySQL?

In order to get last day of current year, you can use LAST_DAY() from MySQL. The syntax is as follows−

SELECT LAST_DAY(DATE_ADD(CURDATE(), INTERVAL 12-MONTH(CURDATE()) MONTH));

Let us implement the above syntax to know the last day of current year−

mysql> SELECT LAST_DAY(DATE_ADD(CURDATE(), INTERVAL 12-MONTH(CURDATE()) MONTH));

This will produce the following output −

+-------------------------------------------------------------------+
| LAST_DAY(DATE_ADD(CURDATE(), INTERVAL 12-MONTH(CURDATE()) MONTH)) |
+-------------------------------------------------------------------+
| 2019-12-31                                                        |
+-------------------------------------------------------------------+
1 row in set (0.00 sec)
Updated on: 2019-07-30T22:30:26+05:30

1K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements