'Postgres ERROR: cannot cast type double precision to date [duplicate]

I have a table with creation timestamps as decimals and am trying to convert to date data type. When I go to cast as date I get the following error message: "ERROR: cannot cast type double precision to date". [column example]

cast(creation_timestamp as date)
postgresqlcastingprecision


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions