Hello, use DATE_FORMAT
"select date_format(datefield, '%d-%m-%Y') as mydate from table"; ~James <[EMAIL PROTECTED]> wrote in message 005e01c200b5$194184c0$0100a8c0@JohnH">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 [EMAIL PROTECTED] www.tececo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php