When I take a (birth) date from the sybase database, Servoy sometimes displays a date which is 1 day earlier or later.
How can this happen and how can it be solved?
Hi Dirk, welcome to the forum!
Does this happen, on the same machine, or on different machines?
look at your locale settings, maybe it is wrong.
You have local settings in your OS, or also in the Servoy client, under Preferences.
Hope this helps
It appears on different machines.
The locales of the OS and Servoy aren’t always the same.
But does a defference in the locales make the date in servoy sometimes be different 1 day?
I can also say that it mostly happens after conversions. But it is still strange that I can see the date in sybase and bot in Servoy (not the same).
Isn’t a date or timestamp universal en undependent from locales?
Dirk:
Isn’t a date or timestamp universal en undependent from locales?
I guess that depends on the column type. Does the column also hold any timezone info?
Hi Dirk, welcome to the forum!
Btw thanx!!
it’s a sybase datetime type
if you use also a timecomponent (for example: 20-10-2007 23:50)
yes the difference can be one day, even if you don’t show the timecomponent!