Re: Syntax for converting double to a timestamp - Mailing list pgsql-general

"Frank Church" <voipfc@googlemail.com> 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