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 по дате отправления:

Предыдущее
От: "Chris White"
Дата:
Сообщение: Re: Getting oid of 0 when doing LargeObjectManager.create()
Следующее
От: "Ulrich Finkler"
Дата:
Сообщение: Problem with jdbc and german special characters under linux...