: [PHP-DB] Date_Format Question
Isn't that what I tried?
Jeff Oien
Although it might be better to format the date in php, don't forget you
can
also do date formating in the select string. The date format functions
for
mySQL can me found here:
http://www.mysql.com/doc/D
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
- 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
- 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