On Thu, March 23, 2006 5:51 pm, Todd Cary wrote: > I have a field, Start_Time, in a MySQL DB. Since it is not a > TimeStamp, I believe I cannot use date(), correct? > > I would like to format 09:00:00 to 9:00 AM. > > If I convert the 09:00:00 with the strtotime(), I get a couple of > extra minutes added.
You may be able to convince MySQL to convert it with a function from http://mysql.com (hint: search for convert) and that might give much more satisfactory results. You should also consider biting the bullet and converting the field to a real 'Time' type. -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
