>>> Rick Emery <[EMAIL PROTECTED]> 03/25/02 11:04AM >>> CORRECTION: SELECT DATE_FORMAT( mydate, "%W, %M %d, %Y") AS thedate FROM mytable; -----Original Message----- From: ROBERT MCPEAK [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 9:58 AM To: [EMAIL PROTECTED] Subject: RE: [PHP] newbyie - date conversion to human readable form This mysql syntax generates an error message. Can you see what's wrong with it? >>> Rick Emery <[EMAIL PROTECTED]> 03/25/02 10:00AM >>> In PHP, you look at the date() function. If retrieving this from a mysql database, mysql will do it for you: SELECT DATE( mydate, "%W, %M %d, %Y") AS thedate FROM mytable; -----Original Message----- From: ROBERT MCPEAK [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 8:55 AM To: [EMAIL PROTECTED] Subject: [PHP] newbyie - date conversion to human readable form I've dug around for a while but I can't find a direct answer on how to convert a date in this format: "2002-03-25" to a human readable format such as " March 25, 2002," or even better, "Monday, March 25, 2002." Can anybody help me with this, or point me to some clear directions on how to do this? Thanks! -- 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
