Reading Postgresql pre-gregorian dates as LocalDates results in mismatching values

[erkieh]

Expected Behavior

Dates before 15 October 1582 are converted to LocalDates preserving the value

Actual Behaviour

Dates before 15 October 1582 are read back with a difference of +6 days.

Conversion seems to happen on

micronaut-data/data-runtime/src/main/java/io/micronaut/data/runtime/convert/DataConversionServiceFactory.java

Line 668 in 59e5d4c

addZonedConvertorsConvertors(conversionService, java.sql.Date.class, date -> instantToZonedDateTime.apply(Instant.ofEpochMilli(date.getTime())));

Date and Instant epoch millis are handled differently before the Julian to Gregorian Calendar switch on 15th October 1582

Steps To Reproduce

No response

Environment Information

No response

Example Application

No response

Version

4.12

[dstepanov]

I think this issue was reported before and the solution is to have your app and your db in the same timezone.

Otherwise please provide a solution.

[erkieh]

This is not about timezones. There will be a difference of 6 days if we use those old dates.

[radovanradic]

The issue was with LocalDate shifting to one 1 day #2096 and it was fixed here #3248
This is something different and is related to the difference between Date and LocalDate calculating dates when Gregorian calendar was introduced. Not sure where we could add this fix.

[dstepanov]

@erkieh Please provide an example project with Micronaut Data that is failing and an alternative in raw JDBC with a date conversions that don't have this error.

[erkieh]

https://github.com/erkieh/reproduce-micornaut-localdate/blob/36263d9de48dd69f5c6d47483846a85a665071ad/src/test/kotlin/com/example/RepoIdTest.kt#L86