DISQUS

DISQUS Hello! Tech-Recipes is using DISQUS, a powerful comment system, to manage its comments. Learn more.

Community Page

Tech-Recipes

Cookbook of Tech Tutorials
Jump to original thread »
Author

Get MySQL date in RFC-822 format for RSS feeds | MySQL | Tech-Recipes

Started by qdideas · 9 months ago

No excerpt available. Jump to website »

2 comments

  • Anonymous

    11 months ago

    Don't use the php DATE('T') if your (tally ho chaps) british, in winter your feed will validate and general work fine, however in sping when day light savings time kicks in it will mysteriously break. PHP pust your timezone as BST or "British Summer Time" which will not validate, where as GMT (grewnich mean time) does.

    You have no idea how long it too me to twig what was wrong...

    Tom
    reply
  • Damian

    1 month ago

    Found this very helpful. The only one thing I would say is that if you try and use ORDERBY rfcpubate DESC in the MYSQL query something weird happens and it doesn't select the most recent. To fix i did this:

    SELECT pubdate, DATE_FORMAT(pubdate,'%a, %d %b %Y %T') AS rfcpubdate FROM tablename ORDERBY pubdate DESC

    very helpful indeed though
    reply

Add New Comment

Returning? Login