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

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