[ADMIN] epoch value different in Postgresql9.0.4 and Postgresql9.6.3

Поиск
Список
Период
Сортировка
От Om Prakash Jaiswal
Тема [ADMIN] epoch value different in Postgresql9.0.4 and Postgresql9.6.3
Дата
Msg-id 1008984454.320532.1498199877441@mail.yahoo.com
обсуждение исходный текст
Ответы Re: [ADMIN] epoch value different in Postgresql9.0.4 andPostgresql9.6.3  (scott ribe <scott_ribe@elevated-dev.com>)
Список pgsql-admin
Дерево обсуждения

At RHEL6.5 32bit OS, PostgreSQL 9.0.4(Attached File IMG_20170623_093733_HDR.jpg)
EPOCH value is different for the same time and data type

from
At RHEL7.3 64bit OS, PostgreSQL 9.4.8.(Attached File IMG_20170623_094034_HDR.jpg


EPOCH value At RHEL7.3 64bit OS, PostgreSQL 9.4.8. and At RHEL7.3 64bit OS, PostgreSQL 9.6.3 are same.

At everywhere I have select 'Asia/Kolkata' time zone in both OS and postgresql.conf file.

Kindly look the matter and resolve the issue.
I am using in a Big project. Now I want to update postgreSQL version. I am getting this problem.
Because of that our client application is displaying actual time + 5:30 Hours.
Now I need to change in client application code to display correct time. Which will increase more man power.

Kindly resolve the issue.

Regards
Om Prakash
DBA, Bangalore
Mob: 9035635787



Вложения

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

Предыдущее
От: Om Prakash Jaiswal
Дата:
Сообщение: [ADMIN] ERROR IN EPOCH DATA TO TIMESTAMP WITHOUT TIME ZONE
Следующее
От: Albe Laurenz
Дата:
Сообщение: Re: [ADMIN] ERROR IN EPOCH DATA TO TIMESTAMP WITHOUT TIME ZONE