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