You have to parse your dates in anyway you like best to pieces, then use mktime() and then date() function. :)
Niklas -----Original Message----- From: Balaji Ankem [mailto:[EMAIL PROTECTED]] Sent: 12. maaliskuuta 2002 12:35 To: [EMAIL PROTECTED]; 'Php-General' Subject: RE: [PHP] Hi How to convert the time from mysql(DATETIME) table to the format DD/MM/YYYY HH:MM AM or PM in PHP? Thankyou for reply!!!!!! I want to do it in PHP. Thanks in advance Balaji -----Original Message----- From: Niklas Lampén [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 4:04 PM To: Php-General Subject: RE: [PHP] Hi How to convert the time from mysql(DATETIME) table to the format DD/MM/YYYY HH:MM AM or PM in PHP? Do you want to do this in mySQL or PHP? Niklas -----Original Message----- From: Balaji Ankem [mailto:[EMAIL PROTECTED]] Sent: 12. maaliskuuta 2002 12:30 To: 'Php-General' Subject: [PHP] Hi How to convert the time from mysql(DATETIME) table to the format DD/MM/YYYY HH:MM AM or PM in PHP? Hi, I have stored the date and time in mysql table with DATETIME type. I want to change it in to DD/MM/YYYY HH:MM AM or PM. How can I do this? Thanks in advance Balaji -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php