[RESOLVED] formatting FROM_UNIXTIME in php

[andynightingale]

I have this date on my page from 'FROM_UNIXTIME' in my SQL query

2005-10-01 08:30:00

How do I get this into 01/10/2005 format without the time? I have tried various combinations of day/month/year, date parameters in my date() function but just seem to get the 1/1/1970 unless I leave the parameters off.

My present code is

<?php echo date($data['day'])?>

[devinemke]

use the DATE_FORMAT fucntion in your query.

[andynightingale]

DATE_FORMAT(MIN(FROM_UNIXTIME(flights.depart_time)),"%D %b %Y") AS day

did the trick.... thank you