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? The DATE function has all kinds of neat formatters, but I do not find any for TIME In DATE, I would say "g:i A" If I try it with a TIME field, I get errors! I HAVE NEVER USED A NEWSGROUP BEFORE, SO I HOPE I HAVE DONE THIS CORRECTLY... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php