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 |
In DBeaver you could setup Timezone in Preferences:
https://i.stack.imgur.com/Sr39v.png