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:
IMG_20170623_093733_HDR.jpg
Description: JPEG image
Attachment:
IMG_20170623_094034_HDR.jpg
Description: JPEG image
-- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
