No...Do it in your query. Use DATE_FORMAT in your query. ---John Holmes...
> -----Original Message----- > From: George Nicolae [mailto:[EMAIL PROTECTED]] > Sent: Saturday, April 27, 2002 12:43 AM > To: [EMAIL PROTECTED] > Subject: [PHP] Re: date format > > 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
