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/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
