camptocamp / GeoMapFish

6 stars 1 forks source link

Bug with timestamp field and editing #49

Open remyguillaume opened 3 years ago

remyguillaume commented 3 years ago

Who requested this new feature?

@gnerred

Is your feature request related to a problem?

Yes Timestamps are out of sync. There is one hour difference. Correct time is in standard query. Time given in editing is wrong.

To reproduce: 1°/ Go to https://preprod.cartoriviera.ch/s/UQbXN 2°/ Connect with c2c account 3°/ Query point number 5 -> Date / heure annonce : 2022-01-15T06:39:00Z 4°/ Query same point with editing -> Date / heure annonce : 2022-01-15 07:39

Describe the solution you'd like

Timestamps should remain synchronized

maltaesousa commented 2 years ago

Look the same as this one https://github.com/camptocamp/GeoMapFish/issues/1

sbrunner commented 1 year ago

GeoMapFish didn't work correctly with timestamp with time zone event, it's the recommended type.

With the column type timestamp without time zone it should work directly.

We have tow think about that we can do to improve the situation: