Postgres Pro
Downloads
Home   >   mailing lists

Conversion of a column from Integer format type to 'timestamp with time zone' - Mailing list pgsql-admin

From Raj kumar
Subject Conversion of a column from Integer format type to 'timestamp with time zone'
Date
Msg-id CACxU--WR-nWB+gVGoTfrvYNb43HxzQNATW7HhSzkw291Qvifeg@mail.gmail.com
Whole thread Raw
Responses Re: Conversion of a column from Integer format type to 'timestamp with time zone'
List pgsql-admin
Tree view
Hi, there is a column 'created' in the 'customers' table which is actually supposed to be a 'timestamp with time zone' column but stored in this Integer format. How do I typecast this to 'timestamp with time zone' format?

select created from customers limit 3;
    created
---------------
 1521521848681
 1508995056368
 1521559994299
(3 rows)

Thanks,
Raj Kumar Narendiran.

pgsql-admin by date:

Previous
From: Massimo Ortensi
Date:
Subject: Re: Problems with unique constraints
Next
From: "David G. Johnston"
Date:
Subject: Re: Conversion of a column from Integer format type to 'timestamp with time zone'