select now(), extract(epoch from now()), -- correct extract(epoch from now() at time zone 'utc'), -- incorrect extract(epoch from now() at time zone 'utc' at time zone 'utc'); -- correct now | date_part | date_part | date_part -------------------------------+------------------+------------------+------------------ 2014-10-14 10:19:23.726908+02 | 1413274763.72691 | 1413267563.72691 | 1413274763.72691 (1 row) https://www.epochconverter.com/