On Thu, Jan 26, 2023 at 12:45 PM Raj kumar <rajkumar820999@xxxxxxxxx> 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.
