On 16-Aug-2001 David Robley wrote:
> 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
>
Ghaakk ...
SELECT DATE_FORMAT(date, '%M %d') as newdate from ...
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
--
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]
