BUG: Fix to_datetime to properly deal with tz offsets #3944

Currently for certain formats of datetime strings, the tz offset will
just be ignored.
Merge pull request #5958 from danbirken/fix-to-datetime-timezone-offset

BUG: Fix to_datetime to properly deal with tz offsets #3944