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 ...

Format "120" is 24-hour time, down to the second. But we limit the size of the result to remove the time component. To include the time component just use a varchar that is 19 or more characters long, ...

Everything else with SQL and DateTime seems to work so well. i.e. it just works I can declare a DateTime in C# and it will drop straight into SQL with no problems or anything.<BR><BR>However, getting ...