How do u convert date time stamp for RSS feed

[BlackRaven]

Need help in converting my sql date time stamp in RSS compatiable. Currently my date time is in this format 2005-12-21 15:34:14

[BlackRaven]

After much googling found this soln

$mysqltimestamp = '2005-05-14 22:37:34';
$pubDate = gmdate('D, d M Y H:i:s \G\M\T', strtotime($mysqltimestamp));
echo $pubDate

[coopster]

You could also use MySQL to do the formatting for you.

SELECT DATE_FORMAT('2005-12-27 22:37:34', '%a, %d %b %Y %H:%i:%s GMT');