Кто-нибудь испытал облегчение от перехода на сабж?

Cf. Jon Skeet https://blog.nodatime.org/2011/08/what-wrong-with-datetime-anyway.html

Тут прямо рекомендуют.

https://www.npgsql.org/doc/types/nodatime.html

Npgsql provides a plugin that allows mapping the NodaTime date/time library; this is the recommended way to interact with PostgreSQL date/time types, rather than the built-in .NET types.