Convert Time Stamp

[iPixel]

I have timestamps stored in the database  2010-03-24 14:15:00 for example.

I need to take the time part of that timestamp and display it like so.

 

2:15pm.

 

Any help is much appreciated.

[PFMaBiSmAd]

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format

[Psycho]

Or in PHP:

$date = '2010-03-24 14:15:00';
echo date('g:i a', strtotime($date));
//Output: 2:15 pm

 

Not sure what is more efficient - extracting from MySQL in the desired format or converting in PHP.

[iPixel]

Like a glove, thank you!