Postgres Pro
Downloads
Home   >   mailing lists

[ADMIN] ERROR IN EPOCH DATA TO TIMESTAMP WITHOUT TIME ZONE - Mailing list pgsql-admin

From Om Prakash Jaiswal
Subject [ADMIN] ERROR IN EPOCH DATA TO TIMESTAMP WITHOUT TIME ZONE
Date
Msg-id 39669097.1721703.1498132923225@mail.yahoo.com
Whole thread Raw
Responses Re: [ADMIN] ERROR IN EPOCH DATA TO TIMESTAMP WITHOUT TIME ZONE  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: EDELPINO
Date:
Subject: Re: [ADMIN] px_resetlog Archiving doesn't work now
Next
From: Om Prakash Jaiswal
Date:
Subject: [ADMIN] epoch value different in Postgresql9.0.4 and Postgresql9.6.3