inserting a timestamp show wrong timezone - Mailing list pgsql-novice

From Pam Wampler
Subject inserting a timestamp show wrong timezone
Date
Msg-id 2E4528861499D41199D200A0C9B15BC0012F4698@taylorwhite.com
Whole thread Raw
Responses Re: inserting a timestamp show wrong timezone  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
When I create a table & insert records, I am getting the wrong timezone info
(-04)
When I insert using now() -- the timezone is right (-05)
I am on EST.   Please help --

example:

 insert into foo  values (3, '12-aug-2001:00:01:01');
insert into foo values (4,now());
showaltb=> select * from foo;
 n |           t
---+------------------------
 3 | 2001-08-12 00:01:01-04
 4 | 2002-02-20 08:59:56-05


pgsql-novice by date:

Previous
From: Pam Wampler
Date:
Subject: Gettting Error When Loading Timestamp Field
Next
From: Francisco Reyes
Date:
Subject: Re: Query between databases?