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/
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter