When you create a timestamp column in PostgreSQL you have to specify if it’s with out without the timezone.
Does Ignition make any difference between the two when it stores a timestamp?
Ignition’s dates are without timezone, so this setting will affect how those timezones are interpreted once they go into the database.
Found my problem, postgresql can have it’s own timezone configured separate for the o/s. I my case it was configured to be GMT. As soon as I commented out the TZ line in postgresql.conf, time stamps in the db started to make sense.
Glad you got it figured out!