How I can change the format of Date in PhpMyadmin

PHP
1

Hi Friends…
I have a table named “news” which contain a “Date” column in default format “y-m-d”.
But I want to change it in “d-m-y”.
I try Date_Format() method to Sql Tab in PhpMyadmin. Query executed successfully but format of date doesn’t change.
Plzzzzzzzzzzzz help me…
d

2

MySQL stores date as YYYY-MM-DD if you use the DATE/DATETIME.
You have to format it when you fetch it out of the database like with PHP functions.

3

actually, that’s not quite accurate, although i can easily see why people would have this impression

mysql requires that date values used in sql are in year-month-day sequence, but the delimiters are optional

so you can use ‘2010-11-15’ or ‘20101115’ or ‘2010$11$15’

internally, however, dates are ~not~ stored that way – they are converted on the way in and stored in a format that you would never figure out, and that you never see, because they are converted on the way out, too, back into YYYY-MM-DD format

4

date(‘d-m-Y’,strtotime($dateretrieved));
To answer the initial question.

5 

SELECT DATE_FORMAT(created_on, '%d-%m-%Y') AS created_on FROM quote



'23-03-2010'
'23-03-2010'
'23-03-2010'
'23-03-2010'
'24-03-2010'
'24-03-2010'
'24-03-2010'
'24-03-2010'