title: Postgres ERROR: cannot cast type double precision to date
body: <p>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: &quot;ERROR: cannot cast type double precision to date&quot;. [<img src="https://i.stack.imgur.com/6OICh.png" alt="column example" />]</p>
  <pre><code>cast(creation_timestamp as date)
  </code></pre>