Received: from pheasant.prod.itd.earthlink.net (pheasant.prod.itd.earthlink.net [207.217.121.20]) by hub.org (8.10.1/8.10.1) with ESMTP id e8LItTs40609 for ; Thu, 21 Sep 2000 14:55:29 -0400 (EDT) Received: from attickswb.mindspring.com (fw-1.pas2.fw.mindspring.net [207.69.129.98]) by pheasant.prod.itd.earthlink.net (8.9.3/8.9.3) with ESMTP id LAA18793; Thu, 21 Sep 2000 11:55:22 -0700 (PDT) Message-Id: <5.0.0.19.2.20000921145244.02438d00@pop> X-Sender: bcdoyle@pop X-Mailer: QUALCOMM Windows Eudora Version 5.0.0.19 (Beta) Date: Thu, 21 Sep 2000 14:55:08 -0400 To: Jie Liang From: "Brian C. Doyle" Subject: Re: Convert from Seconds-Since-Epoch to Timestamp Cc: pgsql-sql@postgresql.org In-Reply-To: <39CA54F2.9818B78@ipinc.com> References: <20000921181036.3514.qmail@web805.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200009/176 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