Time value is one hour 'off' since DST

[dvanhussel]

Hi,

We have a form that displays the time part of a datetime that is fetched from MSSQL. The data is fetched in a table with a column of type 'Time'. This worked as expected. Since Daylight Savings Time is in effect, the values are 'one hour off'.
When I run the sql query directly on the database server, I can see that the actual data is correct.

The strange thing is, that on our development server this problem does not occur. Here the correct data is displayed when using the same datasource.

The date/time settings on both (linux) server are the same (CEST), using ntp. The times logged in catalina.out on this server are also correct.

Is this a setting/configuration option in Ebase that prevents the production server from honouring DST?

For now I have fixed this by checking if DST is in effect in the script en substracting one hour if it is. But that's an ugly solution that should not be necessary.

Regards,

David

[Jon]

David,

Can you check that have the following property in UfsSetup.properties:
Ufs.useSystemTimezone=true

Regards
Jon

[dvanhussel]

Hi Jon,

Thank you for your reply. No, it is not (on both servers). I will try and test this. As a restart is needed, I will do this after office-hours. I'll post the outcome here.

Regards,

David

[dvanhussel]

Hi Jon,

Adding this to UfsSetup.properties indeed fixed this issue.

Thank you!

Regards,

David