[PHP] Time formatting issues

2007-07-14 Thread Melissa
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 TI

RE: [PHP] Time formatting issues

2007-07-14 Thread Jay Blanchard
[snip] 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? [/snip] Have a look at http://www.php.net/mktime -- PHP General Mailing Lis

RE: [PHP] Time formatting issues

2007-07-14 Thread Melissa W. Dickens
Thank you, Jay, that is interesting. I am looking for the am / pm denomination, which I do not see in mktime() I am essentially trying to have the TIME type which is a 24 hour clock display instead as a 12 hour clock with am and pm. I AM A TOTAL NEWBIE, (2ND DAY ever) so if I misunderstood the

Re: [PHP] Time formatting issues

2007-07-16 Thread Chris
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);

Re: [PHP] Time formatting issues

2007-07-16 Thread [EMAIL PROTECTED]
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 no

RE: [PHP] Time formatting issues

2007-07-16 Thread Melissa W. Dickens
Thank you VERY much Jay, Chris and Gary! I tried the php code to change it and that worked Great, as Chris suggested I am about to see how it flies with changing the SQL DB directly as Gary suggested. I might even just ADD a new DB field for the new format... The mktime function looks VERY inte

Re: [PHP] Time formatting issues

2007-07-16 Thread [EMAIL PROTECTED]
Melissa W. Dickens wrote: Thank you VERY much Jay, Chris and Gary! I tried the php code to change it and that worked Great, as Chris suggested I am about to see how it flies with changing the SQL DB directly as Gary suggested. I might even just ADD a new DB field for the new format... The mkt

RE: [PHP] Time formatting issues

2007-07-16 Thread Melissa W. Dickens
Melissa W. Dickens [EMAIL PROTECTED] 770-667-8933 843-838-7388 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 16, 2007 12:50 PM To: Melissa W. Dickens Hmm... Another reason to upgrade! We are running version 4 something or other! -- PHP Gener

Re: [PHP] Time formatting issues

2007-07-17 Thread Richard Lynch
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) > > >