Received: from tidal.ipinc.com (tidal.ipinc.com [199.245.188.85]) by hub.org (8.10.1/8.10.1) with ESMTP id e8LKScs71637 for ; Thu, 21 Sep 2000 16:28:38 -0400 (EDT) Received: from ipinc.com (jliang.ipinc.com [199.245.188.130]) by tidal.ipinc.com (8.9.3/8.9.3) with ESMTP id NAA58089; Thu, 21 Sep 2000 13:28:29 -0700 (PDT) (envelope-from jliang@ipinc.com) Message-ID: <39CA6EA1.5610BD7@ipinc.com> Date: Thu, 21 Sep 2000 13:25:05 -0700 From: Jie Liang Organization: ipinc.com X-Mailer: Mozilla 4.7 [en] (X11; U; FreeBSD 3.4-RELEASE i386) X-Accept-Language: en MIME-Version: 1.0 To: "Brian C. Doyle" CC: pgsql-sql@postgresql.org Subject: Re: Convert from Seconds-Since-Epoch to Timestamp References: <20000921181036.3514.qmail@web805.mail.yahoo.com> <5.0.0.19.2.20000921145244.02438d00@pop> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200009/177 Hi, there, urldb=# create table foo(sec int4); CREATE urldb=# insert into foo values(54321); INSERT 382942319 1 urldb=# select interval(reltime (sec||'secs')) from foo; interval ---------- 15:05:21 (1 row) "Brian C. Doyle" wrote: > how would you do that with in a query? > > ie select date , interval(reltime 'table.secs'); > > when the value in table.secs = 54321 and "secs" is not a part of it? > > At 11:35 AM 9/21/00 -0700, Jie Liang wrote: > >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 -- 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