Parsing RFC822 dates into MYSQL readable dates

[idiparker]

Hi,

I'm wondering if there is an easy command to parse or convert an RFC822 into a UNIX style, ISO8601, MYSQL kind of date? I'm currently parsing some RSS and they use "pubdate" which is RFC822. I want to put this into a MYSQL table, but when I ask to sort by the date field, it sorts alphabetically (I have a date field of a varchar now as using date format just got all messed up).

Is there an easy command, or does anyone know of a script that does it?

[Shrike]

Have a thorough read of the PHP [MAN]strtotime[/MAN] function.