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
[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
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
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);
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
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
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
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
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)
>
>
>
9 matches
Mail list logo