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 56B95DA997 for ; Wed, 26 Oct 2005 06:05:51 -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 03166-09 for ; Wed, 26 Oct 2005 09:05:48 +0000 (GMT) Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.196]) by svr1.postgresql.org (Postfix) with ESMTP id 64337DA95F for ; Wed, 26 Oct 2005 06:05:49 -0300 (ADT) Received: by xproxy.gmail.com with SMTP id i30so195634wxd for ; Wed, 26 Oct 2005 02:05:51 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=hlUL6GimAgoKjw+IR8AKVLCpsqpNjjzZqQV+c76Qb997gc3MJXXnTUEyw8pX4YR9jAXQeZRAni/56dICLBfxwiIZk/X7Ej+9CISCFJD7A5joRK3DthhYUBSZN+daesmiBtSUjjP5V6Bbepor9tByzseJLYrhWulGgmDIWRy1dMQ= Received: by 10.64.249.4 with SMTP id w4mr472111qbh; Wed, 26 Oct 2005 02:05:51 -0700 (PDT) Received: by 10.64.156.9 with HTTP; Wed, 26 Oct 2005 02:05:51 -0700 (PDT) Message-ID: Date: Wed, 26 Oct 2005 14:35:51 +0530 From: Rajesh Kumar Mallah To: pgsql-sql@postgresql.org Subject: converting epoch to timestamp MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.417 required=5 tests=[AWL=0.393, RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200510/314 X-Sequence-Number: 23167 Hi, Can anyone tell me how to convert epoch to timestamp ? ie reverse of : SELECT EXTRACT( epoch FROM now() ); +------------------+ | date_part | +------------------+ | 1130317518.61997 | +------------------+ (1 row) Regds mallah.