Syntax for converting double to a timestamp - Mailing list pgsql-general

I am trying to create a view based on this query

 'select *, "timestamp"::timestamp from ccmanager_log'


This is the error I get to below, how do I use the time zone syntax

error: cannot cast tupe double precision to timestamp without time zone

What is the right syntax?


The column to be converted is also called timestamp

F Church