On 9/4/06, Peter Eisentraut <[EMAIL PROTECTED]> 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/
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
