Re: timezone datetime issue
От
Glenn Pierce
Тема
Re: timezone datetime issue
Дата
Msg-id
CAM5ipV8wFW9nUKu_EwuhtCa7tn1sDt0kcgv6+CMTGHWQ5da3ZA@mail.gmail.com
Ответ на
timezone datetime issue (Glenn Pierce)
Список
Дерево обсуждения
timezone datetime issue Glenn Pierce <glennpierce@gmail.com>
Re: timezone datetime issue Steve Crawford <scrawford@pinpointresearch.com>
Re: timezone datetime issue Albe Laurenz <laurenz.albe@wien.gv.at>
Re: timezone datetime issue Glenn Pierce <glennpierce@gmail.com>
Re: timezone datetime issue Adrian Klaver <adrian.klaver@aklaver.com>
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@gmail.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
В списке pgsql-general по дате отправления
