[SOLVED] PHP Time - Display 20:30:00 as 8.30pm

[mattl]

Hi,

I've a table column called 'time' in mySQL TIME ie HH:MM:SS. I want to display the value in the format h:mm am/pm (20:00:00 becomes 8:30pm).

 

Each value is returned through $row_events['time']

 

I don't really want to modify the mySQL query, so I've tried the following, but to no avail:

 

Code:

<?php

echo time('%h:%i %p', ($row_events['time']));

?>

 

My brain has stopped working! Any suggestions on the above greatly appreciated.

 

Thanks

Matt

[Barand]

<?php
$time = '20:30:00';

echo date ('g:i a', strtotime($time));
?>

[fenway]

You can use TIME_FORMAT() as a MySQL function.

[mattl]

Many thanks, got this working well now.

 

Regards

Matt