Re: Reverse mySQL date
| From: | liljim | Date: | Tue, 21 May 2002 10:48:29 +0000 |
| Subject: | Re: Reverse mySQL date | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-98576@lists.php.net to get a copy of this message | ||
Hello,
use DATE_FORMAT
"select date_format(datefield, '%d-%m-%Y') as mydate from table";
~James
<webmaster@tececo.com> wrote in message
news:005e01c200b5$194184c0$0100a8c0@JohnH...
How can I reverse the date coming out of mySQL?
ie 2002-05-21
becomes 21-05-2002
Can do it in the mySQL query or do I need to use PHP?
Thanks in advance,
JJ Harrison
webmaster@tececo.com
www.tececo.com