ERROR IN EPOCH DATA TO TIMESTAMP WITHOUT TIME ZONE

[Om Prakash Jaiswal <op12om@xxxxxxxxxxx>]

I have converted date/time to epoch value.

Extract epoch from datetimedata

datetimedata is data type TIMESTAMP WITHOUT TIME ZONE.

Now I conveted

epoch value to TIMESTAMP WITHOUT TIME ZONE using

select 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?

Regards

Om Prakash

DBA, BANGALORE INDIA.

MOB: 9035635787