note 9997 added to date
| From: | php-general at list dot php dot net | Date: | Tue, 05 Dec 2000 19:45:32 +0000 |
| Subject: | note 9997 added to date | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-8430@lists.php.net to get a copy of this message | ||
A better solution for dealing with the date format generated by MySQL is to use MySQL's
built-in date_format function. It allows a date to be displayed in almost any conceivable format.
For example: To display the current date in a 'weekday, month date with ordinal, year'
(like Friday, December 8th, 2000) format, use the following query:
SELECT date_format(now(), '%W, %M %D, %Y')
See the MySQL documentation for more details.
http://www.php.net/manual/function.date.php