to change the format of the date in mysql to dd/mm/yyyy

[ajos]

hi friends,
i imported my database from ms access to mysql, there is a problem though the date in mysql has the format (yyyy-mm-dd) and i want to change it to dd/mm/yyyy.how can i do it?i am using phpmyadmin(wamp) to manage my database.please give me a solution to convert the date format from my phpmyadmin.thanks.
regards,
ajos

[ronverdonk]

The DATE data type in MySQL has the format YYYY-MM-DD. But you can re-format the database stored date into DD-MM-YYYY after date calculations and before you display it.

Ronald

[ajos]

The DATE data type in MySQL has the format YYYY-MM-DD. But you can re-format the database stored date into DD-MM-YYYY after date calculations and before you display it.

Ronald

thanks Ronald for the reply can you please elaborate more on this...how should i do that..im using phpmyadmin.
regards,
ajos

[bartonc]

hi friends,
i imported my database from ms access to mysql, there is a problem though the date in mysql has the format (yyyy-mm-dd) and i want to change it to dd/mm/yyyy.how can i do it?i am using phpmyadmin(wamp) to manage my database.please give me a solution to convert the date format from my phpmyadmin.thanks.
regards,
ajos

date_format()

SELECT date_format(dateField, '%d/%m/%Y') as Trans_Date;

[ajos]

date_format()

SELECT date_format(dateField, '%d/%m/%Y') as Trans_Date;

thanks bartonc for the prompt reply,
i did something like this

select date_format(dateField,'%d/%m/%y')as trans_date;

but it gave me an error something like datefield not known.
then i did something like this-->

select date_format(now(),'%d/%m/%y')
 

it served the purpose.
anyways thanks to your answer i got the hint.
regards,
ajos

[pbmods]

Heya, ajos.

MySQL has a system variable called datetime_format.






But it hasn't been implemented yet.