MySQL DATE_FORMAT Function

Example

Format a date:

SELECT DATE_FORMAT("2017-06-15", "%Y");

Definition and Usage

The DATE_FORMAT() function formats a date as specified. Continue reading MySQL DATE_FORMAT Function