select field1,field2,DATE_FORMAT(datefield,"%M %d, %Y"),field4,fieldn from
table;
See the MySQL Manual:
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
On Tue, 16 Jan 2001, Mike Podlesny wrote:
> I want to select all the fields in from the mySQL database except I want my
> date field to be returned in the format of:
>
> January 16, 2001
>
> How can this be done without having to do the select in this manner:
>
> SELECT field1,field2,MONTHNAME(datefield),DAYOFMONTH(datefield),
> YEAR(datefield),field3,field4...etc. FROM table
>
> Thanks for your help
---------------------------------------------------------------------
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