Re: Time formatting issues

Melissa wrote:

I have a DB with a field type DATE (called TideDATE) and a field type TIME (one of which is called highFIRST) How can I format the time fields from displaying 00:00:00 (a 24 hour clock) to HH:MM am/pm format?

$time = '13:05:00'; list($hr, $min, $sec) = explode(':', $time); if ($hr > 12) { $new_time = ($hr - 12); $ampm = 'pm'; } elseif ($hr == 12) { $new_time = '12'; $ampm = 'pm'; } else { $new_time = $hr; $ampm = 'am'; } $new_time .= ':' . $min . ':' . $sec . ' ' . $ampm; pretty simple ;) (I'm sure someone will find a way to make this better but that should work :P). -- Postgresql & php tutorials http://www.designmagick.com/