Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TbYpv-0000Je-Iu for pgsql-admin@postgresql.org; Thu, 22 Nov 2012 15:37:07 +0000 Received: from mail-gh0-f174.google.com ([209.85.160.174]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TbYpt-0002UG-6g for pgsql-admin@postgresql.org; Thu, 22 Nov 2012 15:37:06 +0000 Received: by mail-gh0-f174.google.com with SMTP id g15so898189ghb.19 for ; Thu, 22 Nov 2012 07:37:03 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=from:to:references:in-reply-to:subject:date:message-id:mime-version :content-type:x-mailer:thread-index:content-language :x-gm-message-state; bh=kuZ/SeZVs6lN59BgNQ/Uk7LGwCt4A17Vj0qKFI7RKx4=; b=UrMRIpQ9s94gR81JXf9QpYpfjVU0fKMom85tkhcuN4RaYM/fe54jXXai2DaTK2AtgU pCSYjpbBIa6SuXOlv9o/fl7ctQ0mCjfDDWO+JwWTWhN3kwKPL3fQMRVvlSXP9eluhj6I yePgnLWyTYFZhRftkKEz82owZ3WHWZt87Q/tbF/3hbELEdOkFBYrC4lwLIkLFguilx3w 6S7rIDlIr/tqQKcxNfDkUw2aIQ9r4NN31WXIaDgucbD07DrVwCDuY4jG2Jm2hqehBgsR XjtW0nQwgeaASGDEyVt8lYkTbvBNTXiSaW/5aSkCVleVjcpAL318EswLsK6zVbuDowQP 6qIQ== Received: by 10.236.92.15 with SMTP id i15mr791379yhf.85.1353598623407; Thu, 22 Nov 2012 07:37:03 -0800 (PST) Received: from AnibalVAIO ([190.128.222.90]) by mx.google.com with ESMTPS id s1sm3280432anj.1.2012.11.22.07.36.56 (version=TLSv1/SSLv3 cipher=OTHER); Thu, 22 Nov 2012 07:37:02 -0800 (PST) From: "Anibal David Acosta" To: References: In-Reply-To: Subject: timezone, how postgres deal with it? Date: Thu, 22 Nov 2012 12:36:42 -0300 Message-ID: <004701cdc8c7$3a5cf4b0$af16de10$@devshock.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0048_01CDC8AE.151058F0" X-Mailer: Microsoft Outlook 14.0 Thread-Index: Ac3HaGa1faqv5r8MQk2drsOkqp3XQABXm3wA Content-Language: es-py X-Gm-Message-State: ALoCoQmoMMBnVrfd/HxlOCpeXNFtkmbUfnvZCeRv3Mh8rzWwcd/y+B2szdR4uSot4pUCJy+XQ/MT X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201211/117 X-Sequence-Number: 40362 This is a multipart message in MIME format. ------=_NextPart_000_0048_01CDC8AE.151058F0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit This query returns false select ('2012-11-20 17:00:00-02:00'::timestamp with time zone) = ('2012-11-20 18:00:00-03:00'::timestamp with time zone) But are exactly same time Why? timestamp with timezone just show/hide time zone? thanks ------=_NextPart_000_0048_01CDC8AE.151058F0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

This query = returns false

select ('2012-11-20 17:00:00-02:00'::timestamp with = time zone) =3D ('2012-11-20 18:00:00-03:00'::timestamp with time = zone)

But are exactly same time

Why?

timestamp = with timezone just show/hide time zone?

thanks

------=_NextPart_000_0048_01CDC8AE.151058F0--