[SOLVED] Displaying time from a database?! *solved*

[coalduststar]

Hi - I have an SQL database with separate fields for time and date stored as time and date datatypes.

when I'm pullilng these values out of the database I want to format the date to: dd-mm-yyyy and I want the time to read without the seconds in 12 hour format: hh:ii am/pm.

I can get the current time displayed easily enough but I can't seem to be able to format a stored time:

[code]
        <?php $cream = $row_rsEventsByDate['ev_time'];
  echo $cream = date('g:i a');
?>
[/code]

**it's ok I did some extensive looking through all the stuff on the forum and found an article eventually thanks!**