Issue #2160: event times subject to postgres timezone setting - koji

koji

#2160 event times subject to postgres timezone setting

Closed: Fixed 3 years ago by tkopecek. Opened 4 years ago by mikem.

Unfortunately, Koji's schema uses timezone fields rather than timezonetz fields. Most of the code generally treats these values as unix timestamps, but this is only true if the Postgres server has its default timezone set to UTC.

If the database has a different timezone setting (which seems to be the default), then various times reported by Koji can be offset, such as in #2159

mikem commented 4 years ago

kojitest4=> SET timezone = 'America/New_York';
SET
kojitest4=> select extract(epoch from clock_timestamp());
    date_part     
------------------
 1587077209.14461
(1 row)

kojitest4=> select extract(epoch from clock_timestamp()::timestamp);
    date_part    
-----------------
 1587062811.6566
(1 row)

Metadata Update from @mikem:
- Custom field Size adjusted to None

4 years ago