change date format

[busnut]

G'day

 

I've tried finding the answer on google, but it seems to be giving me the end user result, what i'm looking for is in myphpadmin panel, I want to change the preset date format of 0000-00-00 (which appears to represent year/month/day) to be 00-00-0000 (day/month/year or d/m/Y), but everwhere i've read it shows code you put into the php file.

So currently my 1900 odd records are all in d/m/Y format, and trying to insert all of them into the database is not working as it keeps going back to its date format default.

I've selected 'Date' as the type for this field, so not sure if thats the right thing to do first, if not, what is, and if it is, how do I change the format?

 

Cheers

[Mchl]

You can't change the date format in MySQL. It's fixed, and for a good reason. You can however change the way it is displayed. Most of the time it is done in PHP that's why you get so many hits for that. There are however MySQL date formatting functions.

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html

[busnut]

Ok, so if i've understood this correctly, if i left it as the formated 0000-00-00 (Y-m-d) format, I then change my php pages to show the date in the format I prefer then?

[Mchl]

Yup. And when storing dates, you use either PHP's date or mysql's STR_TO_DATE() to convert dates input in whatever format to MySQL compatible format.