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