Strange behavior of the timezone

From: Vlad Alexeenkov <vladabc(at)yandex(dot)ru>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Strange behavior of the timezone
Date: 2018-03-27 09:40:02
Message-ID: c3770e42-bf2c-7e5d-3bb0-a255fc8cf668@yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi!

Can anyone explain this behavior?

select '1900-01-01 15:11:10'::timestamp t1, '1900-01-01
15:11:10'::timestamp at time zone 'Europe/Moscow' as t2

 t1                                       t2
=================== ===================
01.01.1900 15:11:10 01.01.1900 15:40:53

Strange behavior of the timezone

select version()

version
========================================================================================================

PostgreSQL 9.6.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5
20150623 (Red Hat 4.8.5-11), 64-bit

Thanks

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Robert Zenz 2018-03-27 09:46:32 Re: Strange behavior of the timezone
Previous Message Artem Tomyuk 2018-03-27 09:04:42 autovacuum: vacuum analyze vs autovacuum: vacuum