RE: [PHP] Re: date format
| From: | John Holmes | Date: | Sat, 27 Apr 2002 17:25:32 +0000 |
| Subject: | RE: [PHP] Re: date format | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-94892@lists.php.net to get a copy of this message | ||
No...Do it in your query. Use DATE_FORMAT in your query.
---John Holmes...
> -----Original Message-----
> From: George Nicolae [mailto:geomasterweb@hotmail.com]
> Sent: Saturday, April 27, 2002 12:43 AM
> To: php-general@lists.php.net
> 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" <lalithananth@yahoo.com> wrote in message
> news:20020427064325.2716.qmail@web14002.mail.yahoo.com...
> > 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