Skip to content

Unix Timestamp to Postgres timestamp

sql
INSERT INTO public."MyTable" (related_id, expiration_date)
VALUES (4, ('epoch'::timestamptz + 1769588089 * '1 second'::interval));

-- VALUES (4, ('epoch'::timestamptz + <UnixTimestampHere> * '1 second'::interval));

Reference