We have problem with datetime fields, when we work with HXE using ngdbc.jar (in eclipse or in own application).
Problem is in hours, when summer time is starting/ending.
For example this select shown different data, than are entered:
select to_seconddate('2017-03-26 01:00:00'), to_seconddate('2017-03-26 02:00:00'), to_seconddate('2017-10-29 01:00:00') from dummy;
Bad result: 26.03.2017 00:00:00, 26.03.2017 01:00:00, 29.10.2017 02:00:00
We don't know, how we can turn off this behaviour.