Convert Unix timestamp to timestamp without time zone

Question

How do I convert a Unix timestamp (or epoch time) to a PostgreSQL timestamp without time zone?

For example, 1481294792 should convert to 2016-12-09 14:46:32.

I tried SELECT to_timestamp(1481294792)::timestamp, but that gives me 2016-12-09 09:46:32.

Community · Accepted Answer · 2017-04-13 12:42:39Z

17

SELECT to_timestamp(1481294792) AT TIME ZONE 'UTC';

CommunityBot

11 silver badge

answered Dec 9, 2016 at 20:52

ma11hew28

128k126 gold badges460 silver badges663 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1