Search Postgresql Archives

Re: Syntax for converting double to a timestamp

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux