These days, when I see a datetime column in a csv I have taken to proactively exploding into component pieces and rebuilding as a clean datetime. Just fed up.