From: Om Prakash Jaiswal <op12om@yahoo.co.in>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: epoch value different in Postgresql9.0.4 and Postgresql9.6.3
Date: Fri, 23 Jun 2017 06:37:56 +0000 (UTC)
Message-ID: <1008984454.320532.1498199877441@mail.yahoo.com> (raw)
References: <1008984454.320532.1498199877441.ref@mail.yahoo.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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.
RegardsOm PrakashDBA, BangaloreMob: 9035635787
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-adminAttachments:
[image/jpeg] IMG_20170623_093733_HDR.jpg (2.6M, ../1008984454.320532.1498199877441@mail.yahoo.com/3-IMG_20170623_093733_HDR.jpg)
download | view image
[image/jpeg] IMG_20170623_094034_HDR.jpg (2.9M, ../1008984454.320532.1498199877441@mail.yahoo.com/4-IMG_20170623_094034_HDR.jpg)
download | view image
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: op12om@yahoo.co.in
Subject: Re: epoch value different in Postgresql9.0.4 and Postgresql9.6.3
In-Reply-To: <1008984454.320532.1498199877441@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox