Re: date problem

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" */