mysql date_format?

[lordgreg]

Hello,

i have a column DATE with Type DATE. you all know, that the default format is: yyyy-mm-dd. now,.. how can i retrieve from mysql to php page a date that would look like this: dd-mm-yyyy. select * from...

i don't have a clue..

thank you for your answers,

Gregor

[Anon]

You can use mysql to convert it into timestamp and use the date() function in php.

select *, UNIX_TIMESTAMP(date) as date [...]

$date=date("d-m-Y", $date);

Or you can let mysql do the work:
select *, DATE_FORMAT(date, '%d-%m-%Y') [...]

Good luck.