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

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
unomateo
Forum Newbie
Posts: 4
Joined: Sat Jul 01, 2006 1:36 am

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

Post 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?
User avatar
hawleyjr
BeerMod
Posts: 2170
Joined: Tue Jan 13, 2004 4:58 pm
Location: Jax FL & Spokane WA USA

Post 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
Post Reply