I have trouble loading a file with supposedly valid datetime format. For example a row in the loaded file looks like:
4,0,'2012-08-09 22:34:28','2012-08-09 22:34:28'

The same format works with insert statements. Is this not a valid datetime format when loading? Do we have to specify a default format in any case? Should I cast it?