Re: change date format in MYSQL

[Erik Cerpnjak]

Mysql has this date format: YYYY-mm-dd. You can change the format mysql stores the date, but it is strongly advised and also easier if you only output your date in a format you preffer:

Example:
Lets say you have a collumn named mydate. then you would write your query like this:

SELECT DATE_FORMAT(mydate, '%d/%m/%Y') as mydate from mytable

The date format from your DB looks like this:
2009-02-01

Mysql will output this date as:
01/02/2009

I hope this helps...