On Thu, 16 Aug 2001 00:38, Mike Mike wrote:
> Hello,
> I'm pulling a date out of MySQL as 2001-10-18.
> How do I make it print October 18 in php?
> Thanks much
> --Mike
You could use the Mysql date functions to format it for you. If your date
field is called date and is a date type:
SELECT CONCAT(MONTHNAME(date), ' ', DAYOFMONTH(date)) AS newdate
--
David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc
CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA
I'm Not Schizophrenic, And Neither Am I.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
