CURRENT_TIME and CURRENT_TIMESTAMP give different results in PostgreSQL

57 views Asked by At

CURRENT_TIME and CURRENT_TIMESTAMP give different results in PostgreSQL. What is the reason of that? Why these are not in same timezone?

select current_timestamp, current_time;

results:

current_time current_timestamp
09:13:30 +0200 2023-08-03 10:13:30.122 +0300

Also my timezone is Europe/Istanbul.

SHOW TIMEZONE;
TimeZone
Europe/Istanbul
1

There are 1 answers

1
Julia Maerkina On

In DBeaver you could setup Timezone in Preferences:

https://i.stack.imgur.com/Sr39v.png