| From: | Jeremy Harris <jgh(at)wizmail(dot)org> |
|---|---|
| To: | pgsql <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Timestamp shift when importing data |
| Date: | 2009-01-03 23:24:05 |
| Message-ID: | 495FF395.9090402@wizmail.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Wilson | 2009-01-03 23:26:45 | Re: Timestamp shift when importing data |
| Previous Message | Jolles, Peter M (GE Infra, Energy) | 2009-01-03 22:59:57 | Timestamp shift when importing data |