Date difference on two systems

Questions
1

Hi Guys,

I have a strange issue. My customer has an NG-client solution with a PostgreSQL database. For a specific record a date field in the database has the value 1947-07-11. This is shown correctly locally but on the Server it is shown as 1947-07-10 in the solution. DB Visualizer shows 1947-07-11 on both systems. The date and timezone setting on the server appear to be correct and show the correct date and time. The Servoy server date/time settings are set to default (client machine date/time). Any idea’s?

2

Hi Omar,

to me this still looks like timezone issue.
midnight could result in 11pm on the previous day.

What do you see when you also expose HH:mm of this dataprovider in your solution?

3

Hi Marc,

You are probably right, I asked the administrator to update the TimeZone settings on the server. Once that’s done I’ll check again. Thanks for your time!