| From: | Om Prakash Jaiswal <op12om(at)yahoo(dot)co(dot)in> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | epoch value different in Postgresql9.0.4 and Postgresql9.6.3 |
| Date: | 2017-06-23 06:37:56 |
| Message-ID: | 1008984454.320532.1498199877441@mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| Attachment | Content-Type | Size |
|---|---|---|
| IMG_20170623_093733_HDR.jpg | image/jpeg | 2.6 MB |
| IMG_20170623_094034_HDR.jpg | image/jpeg | 2.9 MB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2017-06-23 11:08:17 | Re: ERROR IN EPOCH DATA TO TIMESTAMP WITHOUT TIME ZONE |
| Previous Message | Om Prakash Jaiswal | 2017-06-22 12:02:03 | ERROR IN EPOCH DATA TO TIMESTAMP WITHOUT TIME ZONE |
