Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f0l5S-0002yL-Gc for pgsql-admin@arkaria.postgresql.org; Tue, 27 Mar 2018 09:40:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1f0l5Q-0001zI-Oh for pgsql-admin@arkaria.postgresql.org; Tue, 27 Mar 2018 09:40:12 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f0l5Q-0001yc-E8 for pgsql-admin@lists.postgresql.org; Tue, 27 Mar 2018 09:40:12 +0000 Received: from forward104j.mail.yandex.net ([5.45.198.247]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f0l5J-00084r-GR for pgsql-admin@lists.postgresql.org; Tue, 27 Mar 2018 09:40:11 +0000 Received: from mxback4j.mail.yandex.net (mxback4j.mail.yandex.net [IPv6:2a02:6b8:0:1619::10d]) by forward104j.mail.yandex.net (Yandex) with ESMTP id 353B942D62 for ; Tue, 27 Mar 2018 12:40:03 +0300 (MSK) Received: from smtp3o.mail.yandex.net (smtp3o.mail.yandex.net [2a02:6b8:0:1a2d::27]) by mxback4j.mail.yandex.net (nwsmtp/Yandex) with ESMTP id VlguhA7XSM-e3WK1O9v; Tue, 27 Mar 2018 12:40:03 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex.ru; s=mail; t=1522143603; bh=KkpjBZqXFph+DMKuaHzpy/SEqRZSVKAbPuDN4a5XYj8=; h=Subject:To:References:From:Message-ID:Date:In-Reply-To; b=FedZWLgq4/7xS69EbW8oeul1P75AVHe+TSqG4BFykiII75VvEctF11iVK7fHQbV1x gPohFzIdbjp7zWSJcYWITR/Mm4f8aeAhiSREvhfkswWxyeI6I8Lk4srna0NWxi0xE3 PiAF7ehOeGNGc9IlAAshalJ7TzaeshLjeX6SWbow= Received: by smtp3o.mail.yandex.net (nwsmtp/Yandex) with ESMTPSA id yAOLZ8esbc-e2Lqu64j; Tue, 27 Mar 2018 12:40:02 +0300 (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client certificate not present) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex.ru; s=mail; t=1522143602; bh=KkpjBZqXFph+DMKuaHzpy/SEqRZSVKAbPuDN4a5XYj8=; h=Subject:To:References:From:Message-ID:Date:In-Reply-To; b=jPNC1wN1ZiwcXJ4HZ8bIZtOU5CpuhVQOhFSoaJOr5eobmJr4jabKKMXqSAtt2oHBY Av2azM9GJtLkcFgM1t0FyUp6xz5dJxERJEbCGAeGb/1LbKq2OyBfYTRN9hSbNkQ1QD PkyoJ0Ihhd6/MGPmbDSuo4pMkv8SueC8lMttAFfI= Authentication-Results: smtp3o.mail.yandex.net; dkim=pass header.i=@yandex.ru Subject: Strange behavior of the timezone To: pgsql-admin@lists.postgresql.org References: From: Vlad Alexeenkov Message-ID: Date: Tue, 27 Mar 2018 12:40:02 +0300 User-Agent: Mozilla/5.0 (Windows NT 6.3; WOW64; rv:52.0) Gecko/20100101 Thunderbird/52.6.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------0111A69163343FE209E99837" Content-Language: ru-RU List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------0111A69163343FE209E99837 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit 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 --------------0111A69163343FE209E99837 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit

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

--------------0111A69163343FE209E99837--