Re: Time formatting issues
| From: | Richard Lynch | Date: | Wed, 18 Jul 2007 01:07:13 +0000 |
| Subject: | Re: Time formatting issues | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-259070@lists.php.net to get a copy of this message | ||
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?