date format

[gktan]

Hello,
I working on this php coding which I retrieve info. from a M. Access server.

$select = "SELECT date FROM table";
$exec = odbc_exec($connection, $select);

$date = odbc_result($exec,1);

The problem is that the value of $date is in the format of eg. 2002-09-27 00:00:00

How can I control the format into just date eg. dd-mm-yyyy or just time hh:mm

Please help
Very much appreciated.
Thanks.
GK

[Anon]

use strftime() turn turn the $date string into a timestamp, and and date() to reformat the timestamp as a string.

[gktan]

I used strftime but it return local time instead. Look thru books and tried strtotime, and its working, but only to a date.
date("h:i A", $time) - is not working.
Can you actually tell me why??

My syntax:
$sdate = strtotime(odbc_result($exec,3));
$stime = strtotime(odbc_result($exec,4));
$etime = strtotime(odbc_result($exec,5));

echo date("d M Y",$sdate); {working}
echo date("H:i A",$stime); {not working}
echo date("H:i A",$etime); {not working}

Thanks again.
GK