convert mysql TIME

[tqla]

hello, I know that I can format a MySQL field with the type DATE like this: date("F j, Y, g:i a");

But how do I format a MySQL field that has a type of TIME?

Thanks.

[taquitosensei]

in mysql

date_format();    you'll have to check to documentation to get all the options.

in php

$formatted_date=date("your date options here", $timestampfrommysql); 

 

[tqla]

So formatting a DATE field and a TIME field both use the date() function.

 

Thanks!

[tqla]

Actually this is not working.

 

My eventTime mysql field is set to TIME and reads like this: 16:00:00

 

So I have done this:

$eventTime = $row_event->eventTime;

$eventTime = date("g:i a", $eventTime);

 

and when I echo it it reads: 12:00 am

 

What am I doing wrong?

[taquitosensei]

I was thinking timestamp not time.

you'll have to convert it to a unixtimestamp

try

$eventTime=date("g:i a", strtotime($eventTime));

[tqla]

Thanks! I was trying mktime when you answered and that almost worked.