Re: Syntax for converting double to a timestamp

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Frank Church" <voipfc(at)googlemail(dot)com>
Cc: "Peter Eisentraut" <peter_e(at)gmx(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Syntax for converting double to a timestamp
Date: 2006-09-04 00:49:34
Message-ID: 2635.1157330974@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Frank Church" <voipfc(at)googlemail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris 2006-09-04 00:50:46 Re: One step install, up and running?
Previous Message Tom Lane 2006-09-04 00:46:27 Re: compressed protocol