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