On 9/4/06, Peter Eisentraut <peter_e@gmx.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/
>