MySQL Date and Time Exercises: Get the last day of the current year

MySQL Date Time: Exercise-5 with Solution

Write a query to get the last day of the current year.

Code:

SELECT STR_TO_DATE(CONCAT(12,31,
      EXTRACT(YEAR FROM CURDATE())), '%m%d%Y');

Sample Output:

STR_TO_DATE(CONCAT(12,31, EXTRACT(YEAR FROM CURDATE())), '%m%d%Y')
2017-12-31T05:00:00.000Z

MySQL Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous:Write a query to get the first day of the current year.
Next:Write a query to calculate the age in year.