Depending on where you are from, where you are working or unique requirements for reporting data and time data can be represented in a variety of different ways and in order to support this MySQL provides two format commands
DATE_FORMAT(date,format)
TIME_FORMAT(time,format)
The date part here is just a Call To a Database Table, Like we have been using
The new part is the format argument, which requires a coded complete format similar to a Regular Expression
And there are quite a few codes for Date and Time Format ...