select last_day(NOW())
DATE_FORMAT(STR_TO_DATE(date, '%Y%m%d'),'%Y-%m-%d ')
*DATE_FORMAT ( Date, format )

SELECT DATE(CONCAT(YEAR(CURDATE()),"-12-31"))