Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2005
    Posts
    36

    Unanswered: Entering RSS date format into MySQL

    Hi,

    I am having trouble entering RSS feed format into MySql database the format for the RSS date is as follows Wed, 28 Dec 2005 18:57:16 GMT how would I enter this into the database any help is appreciated.

    I am using PHP with MySQL.

    Thanks in advance.

  2. #2
    Join Date
    Apr 2005
    Posts
    36
    Hi,

    I have found a way around this problem and thought to post it incase someone else is having the same problem....


    $date = Wed, 28 Dec 2005 18:57:16 GMT;

    $pubDate = strftime ("%Y-%m-%d", strtotime($date));



    will output 2005-12-28 which is compatible with MySQL..

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •