select *,DATE_FORMAT(datecolumn,'%M %D %Y');
On Tue, 16 Jan 2001, Mike Podlesny wrote:
>
> > Thanks for your help but that unfortunately doesn't answer the question,
> > unless I am looking at it wrong. I want the sql statement to read
> something
> > to the affect:
> >
> > SELECT * FROM Table
> >
> > * is about 40 fields, which I do not want to type all of them out
> >
> > so do i do the following?
> >
> > SELECT DATE_FORMAT(*,'%M %D %Y')
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php