Re: Syntax for converting double to a timestamp

On 9/4/06, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
> Frank Church wrote:
> > error: cannot cast tupe double precision to timestamp without time
> > zone
> >
> > What is the right syntax?
>
> It's not clear what the meaning of a double precision as a timestamp
> would be. How about you make that explicit:
>
> "timestamp" * interval '1 second' + timestamp '1900-01-01 00:00:00'
>

I tried the query in this form:

select *, "timestamp" * interval '1 second' + timestamp '1900-01-01
00:00:00' from ccmanager_log

This is the error message

ERROR: operator does not exist: interval + timestamp without time zone
HINT: No operator matches the given name and argument type(s). You
may need to add explicit type casts.

The version I am actually on is 7.4
- Hide quoted text -

> or whatever you had in mind.
>
> --
> Peter Eisentraut
> http://developer.postgresql.org/~petere/
>