Convert 24 Hour time to AM/PM

laurin1

How do I convert 24 Hour time (20:00:00) to AM/PM (8:00:00 PM?

This is stored in a time type field in a MYSQL database.

Mordecai

I'd suggest using a UNIX timestamp, then date()ing it. From MySQL, you can SELECT UNIX_TIMESTAMP().

laurin1

This isn't a dynamic time, but a time entry stored in a field in a database.

TheDefender

You can do the select UNIX_TIMESTAMP as Mordecai said above, or if you prefer to do the conversion in PHP instead of MySQL, you can do it this way.

Sub the $beforetime below for your value from the database...

$beforetime = "20:00:00";
echo "Before Conversion: ".$beforetime."<BR />";

// Make it into a Unix TimeStamp
$convertingtime = strtotime($beforetime);

// Convert it to the format you desire
$endtime = date("g:i:s A", $convertingtime);

echo "After Conversion: ".$endtime;