ERROR IN EPOCH DATA TO TIMESTAMP WITHOUT TIME ZONE

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: ERROR IN EPOCH DATA TO TIMESTAMP WITHOUT TIME ZONE
Date: 2017-06-22 12:02:03
Message-ID: 39669097.1721703.1498132923225@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have converted date/time to epoch value.Extract epoch from datetimedatadatetimedata is data type TIMESTAMP WITHOUT TIME ZONE.Now I conveted
epoch value to TIMESTAMP WITHOUT TIME ZONE usingselect to_timestamp(epoch)
Now I am getting actual value with added value of +5:30.I also used select to_timestamp(epoch) to TIME zone 'IST'THIS is also not giving correct original input data.
this problem is not on Postgresql 9.0.
but now on postgresql9.4.8 version this problem is getting.how resolve it?
RegardsOm PrakashDBA, BANGALORE INDIA.MOB: 9035635787

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Om Prakash Jaiswal 2017-06-23 06:37:56 epoch value different in Postgresql9.0.4 and Postgresql9.6.3
Previous Message EDELPINO 2017-06-22 06:00:01 Re: px_resetlog Archiving doesn't work now