将MYSQL时间转换为PHP时间

Question

I have a column of type time in mysql database, I want to convert it to php time object to be able to use it in some functions, I've tried to use strtotime function but that dosen't work with me, this is my php code:

$result=mysql_query("select time,name from users where user_id='1'");
if($result)
{
    $row=mysql_fetch_array($result);
$time=$row['time'];
    $formatted_time=strtotime($time);               
echo date('H:i:s',$formatted_time);     
}

but what I always get is: 01:00:00 I don't know where the 1 hour did come from!

I know this question may be duplicated but all of answers are talking about using strtotime function which didn't work as you see. could you help pleas?

many thanx in advance

Answer 1

For detail about "TIME_FORMAT" click here

$result=mysql_query("select TIME_FORMAT(`time`, '%h:%i %p') as time, `name` from users where user_id='1'");
if ($result)
{
  $row=mysql_fetch_array($result);
  $time=$row['time'];
  echo $time;
}