problem when exporting field with date data type

[k1n6m4n]

trafficstars

Hi, first of all I want to say thank you to all the contributor for this great tools.

after using this tools for a couple days, I bump into this problem, whenever I export a field with date type with value '0000-00-00' will resulted in '0001-01-01' and while our company old software which is still running vb6 encountered error with this value. (err msg : OLE DB : Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.)

is it anyway to have the exported result of date type to '0000-00-00' ?

thank you

regards Kingman

[adriancs2]

You may add an additional connection string option: convertzerodatetime=false;

Example:

server=127.0.0.1;user=root;pwd=abcd;database=test1;convertzerodatetime=false;