I have a field as type datetime
in a table and the records are shown to me in this format:
YYYY-MM-DD 00:00:00
I understand that it is possible to modify that by entering the structure of any table, editing the field and in the tab where it says:
Display transformation in browser , leave it set as:
Date Format (text/plain: DateFormat)
But in Browser Display Transformation Options I don't really know what to put to show me the date and time in this format:
DD-MM-YYYY 00:00:00
I mention that I already tried with this:
0,'%d-%m-%Y','local'
But it shows me only the date and not the date together with the time , which is what I want to show.
I also include the following image that I found, which is how I want it to show me the date and time, pay attention to the start_time column, this is how I would like it to be in my database.
I would like to be able to do it without code, just modify some option inside MyPHPadmin.
Notice the format you used:
0,'%d-%m-%Y','local'
This is "Day, Month and Year" with the format
03-10-2018.
Now if you want to add the time, you also have to add it to the format:Now look at HM and S which indicate "Hour, Minutes and Seconds". Now the date is displayed in the format
03-10-2018 11:13:45
.