----- 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']

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]

Reply via email to