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

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...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question