Re: 00.00.0000 00:00 is not a valid date and time error on export dataset [1 Attachment]

 Message from: Daniel Hinkle  then export and here is the result:

 00.00.0000 00:00 is not a valid date and time It started doing it before

does the grid actually contain a date column? And if so, are any of them
null?

What do you get if you select min(date_column) from (your query here); ?

I can't see any options to change null dates into all zeros in Toad's
options, but maybe it's an artefact of the format you are attempting to
export - what format have you chosen?


-- 

Cheers,
Norm. [TeamT]



__

Author: Adam Watson
Date: Wed Dec 22 00:54:53 PST 2010
Hi,

When I try and export a results table by clicking the export dataset option after right clicking the results table I get the following error:

00.00.0000 00:00 is not a valid date and time

It started doing it before and I had to uninstall and reinstall to clear it. It has worked fine for a few months but now its back. 

Any ideas that avoid the need to go through the trouble of uninstalling all over again?

Adam
__
_______________________________________