2 ms·
Also if you're worried about the server having a different timestamp and possibly not having configured the connection timestamp correctly, as the following tes
by PaoloBarbolini 3y ago
Also if you're worried about the server having a different timestamp and possibly not having configured the connection timestamp correctly, as the following test shows Postgres always specifies the timezone of the timestamp it's giving you
server=# CREATE TABLE test1 (date TIMESTAMPTZ NOT NULL);
CREATE TABLE
server=# INSERT INTO test1 VALUES (NOW());
INSERT 0 1
server=# SELECT * FROM test1;
date
------------------------------
2023-06-01 08:00:30.40968+02
(1 row)
server=# SET timezone = 'UTC';
server=# SELECT * FROM test1;
date
------------------------------
2023-06-01 06:00:30.40968+00
(1 row)