Postgres Pro
Downloads
Home   >   mailing lists

[ADMIN] epoch value different in Postgresql9.0.4 and Postgresql9.6.3 - Mailing list pgsql-admin

From Om Prakash Jaiswal
Subject [ADMIN] epoch value different in Postgresql9.0.4 and Postgresql9.6.3
Date
Msg-id 1008984454.320532.1498199877441@mail.yahoo.com
Whole thread Raw
Responses Re: [ADMIN] epoch value different in Postgresql9.0.4 andPostgresql9.6.3  (scott ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
Tree view

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



Attachment

pgsql-admin by date:

Previous
From: Om Prakash Jaiswal
Date:
Subject: [ADMIN] ERROR IN EPOCH DATA TO TIMESTAMP WITHOUT TIME ZONE
Next
From: Albe Laurenz
Date:
Subject: Re: [ADMIN] ERROR IN EPOCH DATA TO TIMESTAMP WITHOUT TIME ZONE