note 10229 added to date
| From: | mthorne at nf dot sympatico dot ca | Date: | Wed, 20 Dec 2000 08:30:40 +0000 |
| Subject: | note 10229 added to date | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-8944@lists.php.net to get a copy of this message | ||
I had a problem retreiving the date from my mysql database when I was using the mysql function
date_format() in a complex SQL query. to solve it I used a sql alias, such as
SELECT date_format(datefield,'%M %D %Y') AS nicedate;
then, to get the data into php you use $formatted_date = $row["nicedate"];
http://www.php.net/manual/function.date.php