The date_format function of MySQL should work for time as well... What are the errors? What did you use for the time format? On Sat, July 14, 2007 8:27 am, 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? > > > > 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 > > -- Some people have a "gift" link here. Know what I want? I want you to buy a CD from some indie artist. http://cdbaby.com/browse/from/lynch Yeah, I get a buck. So? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
