Date time problem with timstamp with no timezone data type

Поиск
Список
Период
Сортировка
От Yuva Chandolu
Тема Date time problem with timstamp with no timezone data type
Дата
Msg-id A0F24737FCB34F489EC955D143BDD851BF8504@exchange-sf1.corp.ebates.com
обсуждение исходный текст
Список pgsql-jdbc
Hi,

We have weiered problem with one timestamp(without timezone) data type
column(updated_date) in one table.  We insert a row into this table with
current time once and susequently update it many times with current time.
What happens is with each update the updated_date is increased by 7 hours.
We are in PDT timezone and for initial insert +7 hours is fine but
subsequent updates increasing it by +7 hours is wiered. What should we do
here?

We are using stable pgjdbc2.jar and we are using postgres7.2.1.

Thanks
Yuva

В списке pgsql-jdbc по дате отправления: