pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedepoch value different in Postgresql9.0.4 and Postgresql9.6.3
2+ messages / 2 participants
[nested] [flat]
* epoch value different in Postgresql9.0.4 and Postgresql9.6.3
@ 2017-06-23 06:37 Om Prakash Jaiswal <op12om@yahoo.co.in>
2017-06-23 13:51 ` Re: epoch value different in Postgresql9.0.4 and Postgresql9.6.3 scott ribe <scott_ribe@elevated-dev.com>
0 siblings, 1 reply; 2+ messages in thread
From: Om Prakash Jaiswal @ 2017-06-23 06:37 UTC (permalink / raw)
To: 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.
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-admin
Attachments:
[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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: epoch value different in Postgresql9.0.4 and Postgresql9.6.3
2017-06-23 06:37 epoch value different in Postgresql9.0.4 and Postgresql9.6.3 Om Prakash Jaiswal <op12om@yahoo.co.in>
@ 2017-06-23 13:51 ` scott ribe <scott_ribe@elevated-dev.com>
0 siblings, 0 replies; 2+ messages in thread
From: scott ribe @ 2017-06-23 13:51 UTC (permalink / raw)
To: Om Prakash Jaiswal <op12om@yahoo.co.in>; +Cc: pgsql-admin
Check your postgresql.conf on both, see if you set the default timezone in either.
Also, reconsider seriously whether timestamp without timezone is the correct type for your use here.
> On Jun 23, 2017, at 12:37 AM, Om Prakash Jaiswal <op12om@yahoo.co.in> wrote:
>
>
> 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
>
>
>
> <IMG_20170623_093733_HDR.jpg><IMG_20170623_094034_HDR.jpg>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
--
Scott Ribe
scott_ribe@elevated-dev.com
(303) 722-0567
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2017-06-23 13:51 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-06-23 06:37 epoch value different in Postgresql9.0.4 and Postgresql9.6.3 Om Prakash Jaiswal <op12om@yahoo.co.in>
2017-06-23 13:51 ` scott ribe <scott_ribe@elevated-dev.com>
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