RE: [PHP] Easy Date & MySQL Question...
| From: | John Holmes | Date: | Tue, 25 Jun 2002 15:49:58 +0000 |
| Subject: | RE: [PHP] Easy Date & MySQL Question... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-103796@lists.php.net to get a copy of this message | ||
> I have searched the php.net and don't know where to look for the code
I
> need. I have a MySQL date column that reads this way: 2002-06-25.
> However,
> in PHP I want to show it this way 06/25/2002.
Do the formatting in your query. Use the MySQL function DATE_FORMAT().
Look it up in the MySQL manual, chapter 6: Date and Time Functions...
---John Holmes...