Postgres Pro
Downloads
Home   >   mailing lists

timezone datetime issue - Mailing list pgsql-general

From Glenn Pierce
Subject timezone datetime issue
Date
Msg-id CAM5ipV_Z=S5RtCqqzrH+5WMxEWxju5tGo1NhYsHB4gRvcT154Q@mail.gmail.com
Whole thread Raw
Responses Re: timezone datetime issue  (Glenn Pierce <glennpierce@gmail.com>)
Re: timezone datetime issue  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Re: timezone datetime issue  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-general
Tree view
Hi I have an issue with adjusting a timestamp.

I have a table  like

CREATE TABLE sensor_values
(
      ts timestamp with time zone NOT NULL,
      value double precision NOT NULL DEFAULT 'NaN'::real,
)

It was intended that ts timestamps would be the time we wanted to store in UTC.
Clients would adjust their times to UTC before entering into the database.


Unfortunately some values have been added with BST times.
The DB thinks  they are UTC times but are an hour out this time of year.

Is the a way to adjust those times ? Ie offset the summer times back an hour ?

Thanks

pgsql-general by date:

Previous
From: Tony Theodore
Date:
Subject: Re: Heartbleed Impact
Next
From: Glenn Pierce
Date:
Subject: Re: timezone datetime issue