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;
Could you tell me what I'm doing wrong or how I should do this? Thanks.
Jeff Oien
--
PHP Databas
- 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
>
tions.html
>
> Hope this helps,
>
>
>
> -Original Message-
> From: Jeff Oien [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 29, 2001 8:07 PM
> To: PHP-DB
> Subject: [PHP-DB] Date_Format Question
>
>
> I have a date like this in date format i
- 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 PR
trSQL");
>
> list($formattedDate) = mysql_fetch_array($results);
>
> and you're done!
>
> HTH,
>
> Christopher Oson
>
> -Original Message-
> From: Jeff Oien [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 29, 2001 8:29 PM
> To: