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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
