System.Data.SQLite

 * when you store the date "0001-01-01" (DateTime.MinValue) then rereading the value returns "1899-12-30" (because DateTime.MinValue.ToOADate() returns "0" and not ~"-693593" and so already the storage is wrong)

 * reading correctly stored dates in the range 0001-01-01 till 0099-12-31 throws exception "Not a legal OleAut date" at DateTime.FromOADate()

 * writing any DateTime which is larger than 0001-01-01 and smaller than 0100-01-01 also throws exception "Not a legal OleAut date" at DateTime.ToOADate()


Conclusion: Neither use dateTimeInstance.ToOADate() nor DateTime.FromOADate() for julian day calculations.

I suspect this issue has existed in the code for quite some time?  If so,
changing it now could introduce a backwards compatibility issue (i.e. even
if the current behavior is incorrect).

Some experimental work on this issue is being done on the "newJulianDay" branch,
here:

  [/timeline?r=newJulianDay]

However, these changes will not necessarily be included in a release.  Further
evaluation of them is ongoing.

After some careful testing, I think that the only behavioral difference is going
to be that the new method used will not throw exceptions for the values that are
out of range of an OLE Automation Date.

So chances are high this will included in 1.0.95 or 1.0.96?

Yes, since this change appears to be less risky than my original assessment.

Fixed on trunk via check-in [3bd76a0c9d].  To clarify, this fix *WILL* be in the
1.0.95.0 release.