Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 860981337BB4 for ; Thu, 24 Mar 2011 13:28:23 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 07417-09 for ; Thu, 24 Mar 2011 16:28:13 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7og117.obsmtp.com (exprod7og117.obsmtp.com [64.18.2.6]) by mail.postgresql.org (Postfix) with ESMTP id 9D5BB1337B4E for ; Thu, 24 Mar 2011 13:28:12 -0300 (ADT) Received: from source ([74.125.83.172]) (using TLSv1) by exprod7ob117.postini.com ([64.18.6.12]) with SMTP ID DSNKTYtxGKADb0nTDeq/r1sBJLu3HT9CyMA0@postini.com; Thu, 24 Mar 2011 09:28:12 PDT Received: by mail-pv0-f172.google.com with SMTP id 39so18301pve.31 for ; Thu, 24 Mar 2011 09:28:08 -0700 (PDT) Received: by 10.142.53.18 with SMTP id b18mr6351000wfa.365.1300984088099; Thu, 24 Mar 2011 09:28:08 -0700 (PDT) Received: from [172.24.35.132] ([59.162.78.200]) by mx.google.com with ESMTPS id s41sm80362wfc.3.2011.03.24.09.28.04 (version=TLSv1/SSLv3 cipher=OTHER); Thu, 24 Mar 2011 09:28:06 -0700 (PDT) Subject: Re: converting big int to date Mime-Version: 1.0 (Apple Message framework v1084) Content-Type: text/plain; charset=us-ascii From: Vibhor Kumar In-Reply-To: Date: Thu, 24 Mar 2011 22:00:48 +0530 Cc: pgsql-sql@postgresql.org Content-Transfer-Encoding: 7bit Message-Id: References: To: Sree X-Mailer: Apple Mail (2.1084) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201103/41 X-Sequence-Number: 35243 On Mar 24, 2011, at 2:42 AM, Sree wrote: > How can i convert bigint to date format. > > bigint=616962528000000000 Please explain what;s this value shows. Thanks & Regards, Vibhor Kumar EnterpriseDB Corporation The Enterprise PostgreSQL Company vibhor.kumar@enterprisedb.com Blog:http://vibhork.blogspot.com