We have some data to import, and one column (a tab delimited CSV file) is being imported into a DATETIME column, however it says it cannot import the data - as it ‘cannot be convert to type DATETIME’
It fails on the first row, the example value is;
It’s importing into SQL Server 2012.
I can get it to import by either changing the value to ‘2013/06/15’, or ‘15 june 2013’.
My main problem is, why won’t this import on TOAD 3.5 or 3.6, but will import on 3.1?
Is it that TOAD will not longer convert the value?
Or do I need to change a setting for it to be able to?
Thanks in advance.