automatic time zone conversion

From: Ken Williams <kenw(at)ee(dot)usyd(dot)edu(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: automatic time zone conversion
Date: 2002-06-12 06:35:15
Message-ID: 8E529105-7DCE-11D6-BD3A-0003936C1626@ee.usyd.edu.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm trying to import some data into a table with a column
defined as "timestamp not null". When I defined the table,
postgres seemed to automatically convert the column to
"timestamp with time zone not null", and I can't figure out how
to get rid of the time zone information.

I guess that's question one.

Question two is about how to import data so that time zones are
correct. I'm importing a bunch of dates that occurred in
Sydney, Australia. The dates are spread throughout the year, so
some will be in standard time and some in daylight time. What's
the proper way to let postgres take care of this detail,
figuring out which ones are standard time and which are
daylight? If I don't do this, it seems that all my summer dates
will be 1 hour off, or I'll have to manually figure out which
dates are in which section of the year.

Thanks.

-Ken

p.s. - apologies if this is already answered somewhere. I tried
to search the archive, but got this error:

"could not connect to server: Connection refused Is the server
running on host db.postgresql.org and accepting TCP/IP
connections on port 5433?"

Browse pgsql-general by date

  From Date Subject
Next Message Ken Williams 2002-06-12 06:41:53 automatic time zone conversion
Previous Message Jeff Davis 2002-06-12 06:21:53 packages