RTFM http://www.mysql.com/doc/D/a/Date_and_time_functions.html
select date_format(<DATEFIELD>,"%r") from <TABLE> or select time_format(<TIMEFIELD>,"%r") from <TABLE> Look in the manual for more options... MUCH MORE!!!! :) Anyone know the difference between %h: 01-12 hour notation and %I: 01-12 hour notation ? Kind regards, Jerry > -----Original Message----- > From: Gary [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 06, 2002 3:44 AM > To: [EMAIL PROTECTED] > Subject: [PHP] Convert 24hr to 12hr > > > Hello All, > Can someone please RTFM me so I can convert MySQL 24 hour > time to 12 > hour time. > TIA > gary > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > The information contained in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any form of disclosure, production, distribution or any action taken or refrained from in reliance on it, is prohibited and may be unlawful. Please notify the sender immediately. The content of the email is not legally binding unless confirmed by letter bearing two authorized signatures. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
