Why not change the date format in phpmyadmin?

Hello. I went into the SQL and executed this code
SELECT DATE_FORMAT(`dateend`, '%d.%m.%Y') FROM `main`

where main - is the table and dateend is the column
And my answer, here is the message:
"This selection does not contain a unique column. Change the grid setting show, editing, copying and deleting is impossible."
b881471c91f041cc8d63ccadf5cc1c85.PNG
If you can see at the bottom, as it were, changed the date format, but if I go back to the table, there will be the old date format. Prompt how to be? How to change the date format like this: DD.mm.yyyy?
July 2nd 19 at 14:27
2 answers
July 2nd 19 at 14:29
this command you choose the date and changed the format only for output.
in the database format has not changed - this is normal.
either specify a DATE_FORMAT every time, or to change the settings of the database
How to change the settings? - Prudence_Hartmann60 commented on July 2nd 19 at 14:32
: ochepyatka. not the database, and PMA. The database always stores DATETIME in the form YYYY-MM-DD HH:MM:SS
in the PMA it is possible to customize the output in the desired format stackoverflow.com/questions/22827579/change-the-da... - Arielle15 commented on July 2nd 19 at 14:35
: I could not translate. It is not clear. Interpreter garbage bears. Please explain, where there GMAT? - Prudence_Hartmann60 commented on July 2nd 19 at 14:38
:
Navigate to the page Structure of the corresponding table.
Click Change in the Actions column corresponding to the column date/datetime/timestamp.
Choose Text/Plain: Dateformat from the drop down menu Browser Transformation.
Insert 0,'%d.%b.%Y','local' option change (?).
Save the changes and go back to the page with the browser table. - Arielle15 commented on July 2nd 19 at 14:41
July 2nd 19 at 14:31
If you want to select data, and edit them, then it can (after changing the column type, if necessary):
UPDATE `main` SET `dateend`=DATE_FORMAT(`dateend`, '%d.%m.%Y');


Notice in the yellow box tells you that you can't change the data in the visual editor, phpmyadmin, as insufficient data to determine in which row you want to modify.
Fulfilled. It was 2016-12-03 became 2003-12-20 - Prudence_Hartmann60 commented on July 2nd 19 at 14:34
I believe the phrase "pre-change the column type if necessary" you are noted, and the field type of DATETIME? - Arielle15 commented on July 2nd 19 at 14:37
So I no need. I need a date. - Prudence_Hartmann60 commented on July 2nd 19 at 14:40

Find more questions by tags MySQLDatabases