Re: Formatting a Time field

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

Friday, March 24, 2006, 9:51:48 AM, you wrote:
TC> I have a field, Start_Time, in a MySQL DB.  Since it is not a 
TC> TimeStamp, I believe I cannot use date(), correct?

TC> I would like to format 09:00:00 to 9:00 AM.

TC> If I convert the 09:00:00 with the strtotime(), I get a couple of 
TC> extra minutes added.

TC> Suggestions are welcomed....

TC> Todd


use gmdate() to do the formatting. in strtotime you should give a date something
like
$ftime = gmdate('h:i A',strtotime("2000-01-01 $Start_Time"));

-- 
regards,
Tom

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux