MySQL DATE_FORMAT() Function
MySQL DATE_FORMAT() Function ❮ MySQL Functions Example Format a date: SELECT DATE_FORMAT( "2017-06-15" , "%Y" ); Try it Yourself » Definition and Usage The DATE_FORMAT() function formats a date as specified. Syntax DATE_FORMAT( date , format ) Resource: https://www.w3schools.com/sql/func_mysql_date_format.asp