Re: timezone datetime issue

Although I guess something like this would do it ?

UPDATE sensor_values ts = ts - interval (1 hour) WHERE ts BETWEEN
('2014-03-30 01:00', '2014-10-26 02:00')

On 16 April 2014 11:56, Glenn Pierce <glennpierce(at)gmail(dot)com> wrote:

> 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
>