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
you can make your date returned as
concat(MONTHNAME(field),' ',DAYOFMONTH(datefield),', ',YEAR(datefield))
so that you don't have to handle it as three columns, but regardless
you are goint to have to include all fo the field names in there
(field1, field2, field3, etc)
---------------------------------------------------------------------
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
