Bug with timestamp field and editing

[remyguillaume]

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]

Look the same as this one #1

[sbrunner]

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:

• Document the current situation => Add the list of the supported column types in the editing. c2cgeoportal#10655.
• Make it work with timestamp with time zone this will require a new version of GeoMapFish that needs to update the client and server parts.