On Tue, Jan 16, 2001 at 01:55:01PM -0500, 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 want to use the DATE_FORMAT() function:
DATE_FORMAT(datefield,'%M %e, %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