----- Original Message -----
From: boclair <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; PHP-DB <[EMAIL PROTECTED]>
Sent: Thursday, August 30, 2001 1:09 PM
Subject: Re: [PHP-DB] Date_Format Question
>
> ----- Original Message -----
> From: Jeff Oien <[EMAIL PROTECTED]>
> To: PHP-DB <[EMAIL PROTECTED]>
> Sent: Thursday, August 30, 2001 11:07 AM
> Subject: [PHP-DB] Date_Format Question
>
>
> > I have a date like this in date format in MySQL
> > 2001-08-29
> >
> > and I want it to say
> > August 29, 2001
> >
> > I tried this and it didn't work.
> > select date_format('creation_date', '%b %D, %Y') from Chart_Users;
>
> Perhaps
>
> $result= "SELECT date_format(creation_date,'%b%D,%y') AS created
FROM
> db.Chart_Users";
>
> Then from the array $myrow['created'] instead of
> $myrow['creation_date']
The formatting you need is %M %d, %Y. Careless of me.
Tim Morris
--
PHP Database 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]
