Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 27ABB9FBECA for ; Tue, 3 Apr 2007 12:23:33 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 94552-03-5 for ; Tue, 3 Apr 2007 12:23:19 -0300 (ADT) X-Greylist: delayed 00:17:28.327058 by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id BCBDE9FC059 for ; Tue, 3 Apr 2007 12:16:15 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail.ural.org (mail.ural.org [85.115.166.251]) by svr4.postgresql.org (Postfix) with ESMTP id 482E45AF895 for ; Tue, 3 Apr 2007 14:58:46 +0000 (GMT) Received: from [85.115.165.254] (helo=[85.115.165.254]) by mail.ural.org with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.44) id 1HYkSp-000Cef-KA; Tue, 03 Apr 2007 20:58:27 +0600 Date: Tue, 3 Apr 2007 20:58:15 +0600 From: Alexander Vysokovskih X-Mailer: The Bat! (v3.0) Professional Reply-To: Alexander Vysokovskih X-Priority: 3 (Normal) Message-ID: <713873365.20070403205815@ural.org> To: Mageshwaran Cc: pgsql-admin@postgresql.org Subject: Re: UNIX TIME STAMP In-Reply-To: <4611F0F5.9020308@sifycorp.com> References: <4611F0F5.9020308@sifycorp.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200704/23 X-Sequence-Number: 25087 Hello, Mageshwaran. > Is there any function in postgresql7.1.3 to convert unix time stamp to > normal date and time format select date(timestamp 'epoch' + unixtime_column * interval '1 second') from Table; -- Regards, Alexander Vysokovskih mailto:av@ural.org