note 9997 deleted from date by ronabop
| From: | ronabop@php.net | Date: | Sat, 10 Mar 2001 23:04:15 +0000 |
| Subject: | note 9997 deleted from date by ronabop | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-12221@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.