I am using phpmyadmin 4.8.3 running on Ubuntu 16.04.6 LTS with Mysql 14.14 Distrib 5.6.42. I wanted to change the default format yyyy-mm-dd to dd-mm-yyyy. Based on my research I can do this using "Default transformations for DateFormat" setting. However when I set the new "%d-%m-%Y" format in "Default transformations for DateFormat", it does not change the format of my existing date data or new inserted date. It remains with the yyyy-mm-dd. Is this a bug?

phpmyadmin DateFormat

Please help.

1 Answer

According to the manual atThe DATE, DATETIME, and TIMESTAMP Types, the Y-m-d format is the only format that date fields use internally.

This is the format you must use when inserting data.

You can retrieve dates in whatever format you want:

SELECT DATE_FORMAT(date_field, '%d/%m/%Y')

2

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy