This project has moved. For the latest updates, please go here.
1
Vote

Error DateTime conversion

description

I have some columns datetime adn some date hen I try to backup I get an error.

some rows have '0001-01-01 00:00:00' for datetime and some '0001-01-01' and the error is when I try to backup it cant convert to DateTime because of mindate I guest

thanks for your time and effort

comments

adriancs wrote Feb 26, 2016 at 6:46 AM

try this:

in your connection string, add this option:
convertzerodatetime=true;
example:
server=localhost;user=root;pwd=qwerty;database=test;convertzerodatetime=true;

fretelweb wrote Feb 26, 2016 at 4:08 PM

Thanks you very much it works well now!!!!

adriancs wrote Jun 13, 2016 at 3:17 AM

you're welcome :)