X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9B408DB18D for ; Fri, 28 Oct 2005 01:28:50 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 95212-07 for ; Fri, 28 Oct 2005 04:28:49 +0000 (GMT) Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.192]) by svr1.postgresql.org (Postfix) with ESMTP id 4EC97DB13A for ; Fri, 28 Oct 2005 01:28:49 -0300 (ADT) Received: by xproxy.gmail.com with SMTP id i29so179565wxd for ; Thu, 27 Oct 2005 21:28:46 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=kK65x0BnVC7+3n03YI2oHrtzqcS3E7/PDZiXRW7u2qHqVekVKUNH0urRCrxjFfqYJ4gWMmvH5V+1wDOmcAQq1Qq+3fDpCPhjASCFFlVEvMBG9C4P4X5uc9jFU88an0VdOAY5gewDFDF9VdAMgDhRUoA/Er9a6fZgdS3iM4QN+Is= Received: by 10.65.242.7 with SMTP id u7mr2110856qbr; Thu, 27 Oct 2005 21:28:46 -0700 (PDT) Received: by 10.64.156.9 with HTTP; Thu, 27 Oct 2005 21:28:46 -0700 (PDT) Message-ID: Date: Fri, 28 Oct 2005 09:58:46 +0530 From: Rajesh Kumar Mallah To: Richard Huxton Subject: Re: converting epoch to timestamp Cc: pgsql-sql@postgresql.org In-Reply-To: <435F4AD1.3070605@archonet.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <435F4AD1.3070605@archonet.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.355 required=5 tests=[AWL=0.355] X-Spam-Score: 0.355 X-Spam-Level: X-Archive-Number: 200510/380 X-Sequence-Number: 23233 On 10/26/05, Richard Huxton wrote: > Rajesh Kumar Mallah wrote: > > Hi, > > > > Can anyone tell me how to convert epoch to timestamp ? > > > > ie reverse of : > > > > SELECT EXTRACT( epoch FROM now() ); > > I'd start with either Google or the manuals. > > http://www.postgresql.org/docs/8.0/interactive/functions-datetime.html Firstly Thanks everyone for the response. I did read this document but not too carefully hence missed. I missed because i was not careful and partly because i was not expecting t= hat little note to be under documentation of EXTRACT which deals with getting date/time sub fields. I am no documentation expert just trying to explain why i could not find it. PS: sorry for late reply Regds Mallah. > > Scroll down to the section on "epoch" here and see the example. > > -- > Richard Huxton > Archonet Ltd >