Re: Syntax for converting double to a timestamp

It's generally considered bad form to use reserved words as column names....




""Frank Church"" <voipfc@googlemail.com> wrote in message
news:84b7c6460609031557w1d5aab2t235ff2bdea2124ea@mail.gmail.com...
>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
>