Re: Converting MySQL Date (2001-05-21) to Friendly Date (21 May 2001)

You could consider using DATE_FORMAT() when pulling the date out of the MySQL Table. HAve a look in the mysql manpages for the ezxact syntax Wieger Matthew Ralston wrote: > > I've got a date stored in a MySQL database in a "DATE" field, so it is > stored as "2001-05-21". How do I convert that into a more friendly date like > "21 May 2001" or even "21st May 2001" for display on a web page? > > I've tried > > print date("jS F Y", $dbtable[date]); > > but I always get "1st January 1970" because I don't know how to convert the > MySQL date into a PHP timestamp. > > Can someone tell me how to do it please? > > -- > Thanks, > > Matt > matthew.ralston@haltoncollege.ac.uk > < www.mralston.co.uk /> > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- Wieger Uffink tel: +31 20 428 6868 fax: +31 20 470 6905 web: http://www.usmedia.nl