#2160 event times subject to postgres timezone setting
Closed: Fixed 2 years ago by tkopecek. Opened 2 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


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

2 years ago

Metadata Update from @tkopecek:
- Issue set to the milestone: 1.22

2 years ago

Metadata Update from @jcupova:
- Issue tagged with: testing-ready

2 years ago

Metadata Update from @mfilip:
- Issue tagged with: testing-done

2 years ago

Login to comment on this ticket.

Metadata
Related Pull Requests
  • #2237 Merged 2 years ago