X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 1568A9FA502 for ; Thu, 20 Jul 2006 08:42:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 60541-08 for ; Thu, 20 Jul 2006 08:42:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from coe.tamu.edu (edsun.coe.tamu.edu [165.91.232.6]) by postgresql.org (Postfix) with ESMTP id D56559FA4AE for ; Thu, 20 Jul 2006 08:42:16 -0300 (ADT) Received: (from root@localhost) by bruner.coe.tamu.edu (8.13.1/8.13.1) id k6KBfwiB024321; Thu, 20 Jul 2006 06:41:58 -0500 Received: from coe.tamu.edu (coe.tamu.edu [165.91.232.6]) by coe.tamu.edu (8.11.7p2+Sun/8.12.11) with ESMTP id k6KBfqC07528; Thu, 20 Jul 2006 06:41:52 -0500 (CDT) Date: Thu, 20 Jul 2006 06:41:49 -0500 (CDT) From: "Ben K." To: LiveShell cc: hubert depesz lubaczewski , pgsql-admin@postgresql.org Subject: Re: biginteger to timestamp In-Reply-To: <928fe9b50607200241pea3a0bej11083ebd45dae8d4@mail.gmail.com> Message-ID: References: <928fe9b50607200226w3c9eca67h5e0e5d9a4466aeef@mail.gmail.com> <9e4684ce0607200232j5db5ddcdp8ba85ee5b212fbfa@mail.gmail.com> <928fe9b50607200241pea3a0bej11083ebd45dae8d4@mail.gmail.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by AMaViS 0.3.12 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/166 X-Sequence-Number: 22412 > actally i have UNIX time and that is in *1153222974* format. and i m using select to_timestamp(1153222974); http://www.postgresql.org/docs/8.1/static/functions-formatting.html if you're on 8.1. HTH. Ben K. Developer http://benix.tamu.edu