Received: from smtp-2.ig.com.br (smtp-2.ig.com.br [200.225.157.61])
	by hub.org (8.10.1/8.10.1) with SMTP id e97CNkJ10864
	for <pgsql-sql@postgresql.org>; Sat, 7 Oct 2000 08:23:47 -0400 (EDT)
Message-Id: <200010071223.e97CNkJ10864@hub.org>
Received: (qmail 7743 invoked from network); 7 Oct 2000 12:23:35 -0000
Received: from unknown (HELO MYHOSTNAME) (200.217.201.172)
	by smtp-2.ig.com.br with SMTP; 7 Oct 2000 12:23:35 -0000
From: "Edipo E. F. Melo" <edipoelder@ig.com.br>
To: "pgsql-sql" <pgsql-sql@postgresql.org>
Date: Fri, 06 Oct 2000 23:56:12 -0300 (ADT)
Reply-To: "Edipo E. F. Melo" <edipoelder@ig.com.br>
X-Mailer: (Demonstration) PMMail 2.00.1500 for OS/2 Warp 4.00
In-Reply-To: <17093.970235907@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Subject: Re: Date problem
X-Archive-Number: 200010/79

On Fri, 29 Sep 2000 09:58:27 -0400, Tom Lane wrote:

	Returning from previous thread, i found a solution for my
problem: "when everything fails, read the manual..."
	Reading the OS/2 command reference, it says that TZ has three
parts: XXXCYYY. XXX - is the timezone name, C is the increment from UTC
time, and YYY is the name of summertime.
	Ommiting the name of summertime (TZ=AST4), pgsql returned the
correct select.

>>> Not sure how this would apply to 2000-01-01, though.  What timezone
>>> are you in, anyway?
>> 	OS/2 sets TZ=AST4ADT (I live in Brazil, Natal city).
>
>Hm.  On a RedHat Linux box, with pgsql 7.0.2:
>
>regression=# show TimeZone ;
>NOTICE:  Time zone is AST4ADT
>SHOW VARIABLE
>regression=# select '2000-01-01'::date::timestamp;
>        ?column?        
>------------------------
> 2000-01-01 00:00:00-04


    []'s

    Edipo Elder F. de Melo