RE: [PHP] Date Conversion
| From: | John W. Holmes | Date: | Thu, 20 Mar 2003 02:55:47 +0000 |
| Subject: | RE: [PHP] Date Conversion | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-140392@lists.php.net to get a copy of this message | ||
> when retrieving a date from MySQL in nYYYY/MM/DD, how can I present
this
> to
> the user of a site in readable format i.e. 19th March 2003?
SELECT DATE_FORMAT(column,' ... ') AS f_date FROM table WHERE ...
Look up DATE_FORMAT in the MySQL manual, Chapter 6. It works almost the
same as the PHP date() function. The ' ... ' would be the pattern to
create '19th March 2003'
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/