"Frank Church" <[EMAIL PROTECTED]> writes: > I tried the query in this form:
> select *, "timestamp" * interval '1 second' + timestamp '1900-01-01 > 00:00:00' from ccmanager_log Try timestamp plus interval, instead of the other way. (We did add the operator in this direction in 8.0 though ... perhaps you should consider an update sometime?) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq