Re: Timestamp shift when importing data - Mailing list pgsql-general

From Jeremy Harris
Subject Re: Timestamp shift when importing data
Date
Msg-id 495FF395.9090402@wizmail.org
Whole thread Raw
In response to Timestamp shift when importing data  ("Jolles, Peter M (GE Infra, Energy)" <peter.jolles@ge.com>)
List pgsql-general
Jolles, Peter M (GE Infra, Energy) wrote:
> I am trying to migrate several years of historical data with timestamps
> from an MS Access database to Postgres. I am running into an issue where
> specific dates/times get pushed one hour ahead, which creates duplicate
> date/time stamps or failes the import if I have that defined as my
> primary key. The time that gets shifted is always 2:00 AM to 2:55 AM
> (data is in 5 minute blocks). What I don't understand is that it only
> seems to happen on the following dates (m/d/yy format):
>
> 4/7/02
> 4/6/03
> 4/4/04
> 4/3/05
> 4/2/06

Daylight savings time shift?
- Jeremy

pgsql-general by date:

Previous
From: "David Wilson"
Date:
Subject: Re: Timestamp shift when importing data
Next
From: Thomas Kellerer
Date:
Subject: Re: PostgreSQL 8.4 download?