Why does postgres work with timezones so strangely?

N

N

NubasLol2020-08-13 22:48:16

PostgreSQL

NubasLol, 2020-08-13 22:48:16

Why does postgres work with timezones so strangely?

select timezone('+03:00 UTC', now()), timezone('Europe/Minsk', now())

Outputs 2020-08-13 17:46:29.670451, 2020-08-13 22:46:29.670451

Why in 1 case it took 3 hours

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

E

edo1h, 2020-08-14
@edo1h

in the timezone, the offset is indicated with a different sign
https://unix.stackexchange.com/questions/104088/wh...

Similar questions

E

eldar_web2019-05-23 19:24:24

How can I set the sort sequence in SQL (postgresql)? 2Reply

D

dima_ikar2019-05-26 00:30:18

How to configure PHP file to work with PostgreSQL instead of MYSQL? 3Reply

D

devilsD2019-06-01 00:34:56

How to fix django migration error when creating column of type ArrayField? 0Reply

A

Alexey Trigubin2021-01-26 15:06:14

How to update the data if it already exists and add it if it doesn't exist? 2Reply

M

MoonMeTwice2021-01-26 18:56:21

How to update data in an associative table? 0Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question