try <? $date="2002-04-27";
echo date("d-m-Y",strtotime($date)); ?> -- Best regards, George Nicolae IT Manager ___________________ PaginiWeb.com - Professional Web Design www.PaginiWeb.com "Ananth Rajaraman" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi all, > I'm trying to query a date field from mySQL and > display in a differnet format. > > the mysql date is in the format YYYY-MM-DD and I want > to convert it to DD-MM-YYYY > > how do I do that? > > TIA > > Ananth > > ===== > visit www.locustechnologies.com > > __________________________________________________ > Do You Yahoo!? > Yahoo! Health - your guide to health and wellness > http://health.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php