Date problem

How do I get a date from a database in the right format.

It is written like this in a mysql date field 2007-04-02
But how do I get it to write 02/04-2007 when I get it from the database.

I thought it was like $date=date($row['Date'], "d/m-Y")
this but it doesn't work.
I get the error Warning: date() expects parameter 2 to be long

$mysqlday="2007-04-02";
echo date("d/m-Y",strtotime($mysqlday));

You can do it directly in the SQL if you want:

SELECT DATE_FORMAT(date_col, '%d/%m-%Y') AS date_dmy FROM table_name;

Good answer NogDog!

Yes.. off cause date_format in the select ...
Why didn't I think of that :o)

Thanks a lot

Don't forget to mark this thread resolved.