[SOLVED] Easy Date Formatting Question

[webref.eu]

Hi All

 

I'm lifting a date and time field from my database and displaying it on the page with:

 

echo "Date Added: " . $row[ProductDateAdded] . "<br /><br />";

 

which gives me date and time results like: 

 

2009-06-02 11:38:35

 

However, I just want the date formatted to an American standard as follows: 

 

Jun 2 2009

 

So what's the code to do that please? 

 

Many thanks

 

 

[PFMaBiSmAd]

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format

[webref.eu]

OK, thanks, the code I needed was:

 

echo "Date Added: " . date('M d Y', strtotime($row[ProductDateAdded])) . "<br /><br />";

 

Rgds

[PFMaBiSmAd]

Changing the format in the SELECT query is 8-10 times faster than using php code, in case you have a lot of data or your site has a lot of visitors. (Edit: actually the time it adds to the query, that you are executing anyway, makes it several hundred times faster than using php code.)