Here is a suggestion for a function to convert RFC 822 to SQL Server DATETIME in specified zone. I didn't see an existing function to take string dates in this format to a sql server datetime format ...