I am having issues outoutting dates in the correct format for RSS feeds, they're simply not parsing the dates the way I would like, and a format which the rss readers support

Currently the dates are formatted in 2010-10-05

I need to have the dates listed in this format Wed, 13 Oct 2010 05:23:50 +0000

Is there a PHP code that can convert the former into the latter, the database has the former listed.

The current code used to pull the dates is

<?php echo $row_rss['post_date']; ?>

WHich grabs the date from the post_date field and outputs it.

I don't really know RSS, just know a bit of html so if you could rewrite the above code with the required data format (DATE_RFC822)

That would be a great help..

The php date function has this built in.

PHP Code:

date('r') 


The date function also takes in a parameter.

PHP Code:

/* if your variable is type date already */
date('r',$row_rss['post_date'])

/* if your variable is type string */
date('r',strtodate($row_rss['post_date'])) 


Hi portkey

Thanks for the speedy response.

The field in the database is currently set to date, I also played aroun d with your solution while setting the field to datetime.

However it doesn't seem to work, as the date output from 1970 and 1969, but I can clearly see that the database table contains the correct dates.

Could it be that the PHP version may not be compativle with the solution you provided? in which case is there something else I could try.

MySQL version 5.1.47-community-log
PHP version 5.2.14

portkey, I got it to work

PHP Code:

date('r', strtotime($row_rss['post_date'])) 


seemd to work fine it's looks almost the same, but there is a space after,

could that be the reason why it didn't work before?