Horton

Re: Convert from Seconds-Since-Epoch to Timestamp

Jie Liang <jliang@ipinc.com>

View thread View on postgr.es
From: Jie Liang <jliang@ipinc.com>
To: Webb Sprague <wsprague100@yahoo.com>
Cc: pgsql-sql@postgresql.org
Date: 2000-09-21T18:35:30Z
Lists: pgsql-sql 
Hi, Webb,

I am not quit sure what you really want to do, however, I assume that
following maybe
what you mean:


db=# select interval(reltime '12313221 secs');
      interval
--------------------
 4 mons 22 12:20:21
(1 row)


Webb Sprague wrote:

> Hi all,
>
> How do I convert from seconds (an integer) to
> timestamp?
>
> I am sure it is easy, but I can't find it in the docs,
> so far.
>
> Thanks
> Webb
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo! Messenger.
> http://im.yahoo.com/

--
Jie LIANG

Internet Products Inc.

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang@ipinc.com
www.ipinc.com