[SOLVED] Reformat Date

[refiking]

How can I reformat the date from mysql format to M d Y format?  Here is what I did so far:

 

$mon = date("M d Y", $row['mon']);
$exp = date("M d Y", $row['exp']);

 

 

 

[The Little Guy]

If you don't already, you should format the rows as Unix timestamps.

 

$mon = date("M d Y", strtotime($row['mon']));
$exp = date("M d Y", strtotime($row['exp']));

[Ken2k7]

What is $row['mon']?

[refiking]

they are dates from the database

 

For example, one record is 2005-03-12

[Ken2k7]

Use SQL -

SELECT DATE_FORMAT(mon, '%M %d %Y') AS mon, DATE_FORMAT(exp, '%M %d %Y') AS exp
FROM table;

[refiking]

That won't work because I need to have it unformatted as well as formatted.  However, I decided to use the strtotime function, just in case anyone else runs into the same dilemna.  Here's my code:

$mon = date("M d Y",strtotime($row['mon']));

[Ken2k7]

It would work if you change it to -

SELECT DATE_FORMAT(mon, '%M %d %Y') AS formatted_mon, DATE_FORMAT(exp, '%M %d %Y') AS formatted_exp
FROM table;