Change date format in MYSQL

Sometimes the situation may demand to change the MYSQL date format, when we are using select query. MYSQL has builtin functions for this purpose, take a look at example below…