"Frank Church" <voipfc@xxxxxxxxxxxxxx> 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