On Sunday 28 April 2002 21:10, Nick Wilson wrote:
> * and then Richard Emery declared....
>
> > Third, let Mysql do the conversion for you. For instance if you
> > timestamp field is named "mydate":
> > SELECT DATE_FORMAT(mydate,"%e %b %Y") AS thedate FROM mytable
>
> Nice one, cheers Richard.
> I didn't know about that mysql function...
Can we say, RTFM :)
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
Everything is possible. Pass the word.
-- Rita Mae Brown, "Six of One"
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
