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

From David G. Johnston
Subject Re: Conversion of a column from Integer format type to 'timestamp with time zone'
Date
Msg-id CAKFQuwZYWsBb49OZsS=H-SDhCu2_tSFiypiX7mfbQTyAZMobWg@mail.gmail.com
Whole thread Raw
In response to Conversion of a column from Integer format type to 'timestamp with time zone'  (Raj kumar <rajkumar820999@gmail.com>)
Responses Re: Conversion of a column from Integer format type to 'timestamp with time zone'
List pgsql-admin
On Thu, Jan 26, 2023 at 12:45 PM Raj kumar <rajkumar820999@gmail.com> wrote:
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)


We have no way of knowing what the corresponding point-in-time a 0 in that column represents.  Or, for that matter, what a 1 means.

David J.

pgsql-admin by date:

Previous
From: Raj kumar
Date:
Subject: Conversion of a column from Integer format type to 'timestamp with time zone'
Next
From: Tom Lane
Date:
Subject: Re: Conversion of a column from Integer format type to 'timestamp with time zone'