MySQL’s date field type default is in yyyy-mm-dd format, and it is not practical in some cases when we want to use another formating representation such as dd/mm/yyyy. Of course we could use PHP to convert it but the best way I find is to convert it through SQL before any php operation, here is an example which I which like to show you:

Editor’s note: I recently worked on a web project which I need to add the date on a page. I used the PHP function date( ) to accomplish the job. Here are my examples for your reference.