Unix Timestamp in PostgreSQL

Look up the current epoch time and convert between Unix seconds and UTC dates in PostgreSQL.

Get the current timestamp

SELECT floor(EXTRACT(EPOCH FROM clock_timestamp()))::bigint;

Timestamp to date

SELECT to_timestamp(1700000000) AT TIME ZONE 'UTC';

Date to timestamp

SELECT EXTRACT(EPOCH FROM TIMESTAMPTZ '2023-11-14 22:13:20+00')::bigint;

Open 1700000000 in the converter

Current Unix time

Seconds—

Milliseconds—

UTC: —
My time zone: —

Official reference ↗

Free to use. Your input stays in this browser.

How to use it

Copy the current-time example into your PostgreSQL environment to read Unix seconds.
Run the second example to display 1700000000 as a UTC date.
Run the last example to convert that date back into seconds.

Extract epoch from timestamptz to represent an absolute instant. to_timestamp returns timestamptz, whose display depends on the session zone unless you request UTC.