HHH-18589 Properly handle temporals in BC era

[beikov]

[Please describe here what your change is about]

---

By submitting this pull request, I confirm that my contribution is made under the terms of the Apache 2.0 license and can be relicensed under the terms of the LGPL v2.1 license in the future at the maintainers' discretion. For more information on licensing, please check here.

---

https://hibernate.atlassian.net/browse/HHH-18589

[beikov]

This PR also addresses some issues with date conversion between java.time other APIs where the same epoch millisecond might mean different dates for various reasons. It's also worth to mention that the JDBC drivers sometimes rely on a certain epoch millisecond interpretation when passing temporal values, which needs to be accounted for. I assume that this is the reason for failures in Quarkus: https://github.com/quarkusio/quarkus/issues/37720

[hibernate-github-bot[bot]]

Thanks for your pull request!

This pull request does not follow the contribution rules. Could you have a look?

❌ All commit messages should start with a JIRA issue key matching pattern HHH-\d+     ↳ Offending commits: [271121b0b2b56bd91701b8ef15fce28e67567877]

› This message was automatically generated.