Page 1 of 1

date format for rss, atom, opml feeds for insert into mysql

Posted: Wed Jul 05, 2006 10:02 pm
by unomateo
Seems like all the different type of syndication feeds have different datetime formats.

I want to insert feeds into a mysql database and then search them based on the date.

I need to put them in Y-m-d format.

Do I have to write a date parser for each type of feed, or are there tools that already do this?

Posted: Wed Jul 05, 2006 11:38 pm
by hawleyjr
This may help:

strtotime()

Also, don't forget to check out the mysql date functions:

http://dev.mysql.com/doc/refman/5.0/en/ ... tions.html