In database, my date field are all stored in UTC using this format : 2020-12-15T16:24:00.000000000
The issue is the date field that named with a leading underscore such as _CREATE_DATE, _LAST_UPDATE, store data in server time (which used to be in GMT 8).
What have I done to fix this?
-
I have changed the servertime from GMT 8 (default when using alibaba server) to UTC, but the table still use GMT 8 when write new record.
-
I check postgres DB timezone, and the timezone is in GMT 7
It seems like ODK already remember the previous server setting thus keep making new record in the gmt 8 timezone. Is there a way to fix this? Any help would be appreciated