[SOLVED] Format MySQL Date

[chordsoflife]

I have a date column in a MySQL database and I call it onto a page with PHP but I don't want it in the format MySQL has it. It comes in 2008-02-22 and I want it two ways:

 

1. Feb 22, 2008

2. 022208

 

Any way to do that?

[pocobueno1388]

Look at the MySQL DATE_FORMAT() function.

[rhodesa]

Should be

 

SELECT DATE_FORMAT(date_column,'%b %e, %Y') FROM table_name

and

SELECT DATE_FORMAT(date_column,'%m%d%y') FROM table_name

[Barand]

Your other option is to format on output using PHP date() function

 

www.php.net/date

[chordsoflife]

Thanks for the replies. I've already stored all the data in an array, so I don't want to select anything from the database anymore. Basically, this is where I'm at:

 

$concert['date'] = DATE_FORMAT($concert['date'],'%b %e, %Y');

 

But that doesn't work, of course. Any suggestions?

[Barand]

Your other option is to format on output using PHP date() function

 

www.php.net/date

[rhodesa]

No, just modify your SELECT statement...no need to do an EXTRA select. What is your SELECT statement?

[chordsoflife]

here's the who shabang (well... not all of it):

 

//select the database I want
mysql_select_db("archive", $connection);


//store the database in an array
$result = mysql_query("SELECT * FROM concerts");


//format the date correctly
$concert['date'] = DATE_FORMAT($concert['date'],'%b %e, %Y');

//spit out one result in this format at a time
while($concert = mysql_fetch_array($result))
  {
  echo "

 

Barand- I'm looking into doing it with PHP too, I'm just not sure how to format it and keep getting errors, but I'm trying to work through it, so I'll learn. Super newbie here with a strong desire to learn.

[rhodesa]

//select the database I want
mysql_select_db("archive", $connection);


//store the database in an array
$result = mysql_query("SELECT *,DATE_FORMAT(`date`,'%b %e, %Y') as fdate  FROM concerts");

//spit out one result in this format at a time
while($concert = mysql_fetch_array($result))
  {
  echo $concert['fdate'];

[rhodesa]

or with php...

 

//select the database I want
mysql_select_db("archive", $connection);


//store the database in an array
$result = mysql_query("SELECT * FROM concerts");

//spit out one result in this format at a time
while($concert = mysql_fetch_array($result))
  {
  echo date('M j, Y',strtotime($concert['date']));

[chordsoflife]

Awesome, thanks, worked like a charm.