> when retrieving a date from MySQL in nYYYY/MM/DD, how can I present this > to > the user of a site in readable format i.e. 19th March 2003?
SELECT DATE_FORMAT(column,' ... ') AS f_date FROM table WHERE ... Look up DATE_FORMAT in the MySQL manual, Chapter 6. It works almost the same as the PHP date() function. The ' ... ' would be the pattern to create '19th March 2003' ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
