MySQL supports formatting the datetime values into a different formats using DATE_FORMAT() function. This function accepts date/datetime values as a first parameter and returns into a specific format defined as a second parameter. Let us explore this with the following examples which are self-explanatory Define a DATETIME variable SET @date:='2014-06-16…