| Well, I don't want to use datetimeoffset, I kind of _need _to. In SQL Server it's the only proper way to store dates in time zone independent manner, i.e. that is safe to use if I expect the application host to move to a different time zone at some point in the future. SQL Server has no other equivalent to the standard type timestamp with time zone. If I use datetime2, dates are not stored in UTC but in system-local time, which means they are only valid as long as the application will always remain in the same system time zone. Since I'm just a user of Hibernate and, honestly, much of it is a black box to me even after many years of experience, disseminating the MSSQL JDBC driver will not help me much with fixing or working around this issue. |