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"))