On Sep 4, 2006, at 7:57 , Frank Church wrote:
I am trying to create a view based on this query 'select *, "timestamp"::timestamp from ccmanager_log'
<snip />
What is the right syntax?
Try this:
select *, to_timestamp("timestamp") from ccmanager_log
http://www.postgresql.org/docs/current/interactive/functions-
formatting.html#FUNCTIONS-FORMATTING-TABLE
Does it do what you want? Michael Glaesemann grzm seespotcode net
