X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id F10229FA4A8 for ; Fri, 21 Jul 2006 14:42:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 12952-03 for ; Fri, 21 Jul 2006 17:42:10 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from wolff.to (wolff.to [66.93.197.194]) by postgresql.org (Postfix) with SMTP id 08DB49FA68D for ; Fri, 21 Jul 2006 14:42:08 -0300 (ADT) Received: (qmail 9441 invoked by uid 500); 21 Jul 2006 17:47:45 -0000 Date: Fri, 21 Jul 2006 12:47:45 -0500 From: Bruno Wolff III To: LiveShell Cc: hubert depesz lubaczewski , pgsql-admin@postgresql.org Subject: Re: biginteger to timestamp Message-ID: <20060721174745.GA3490@wolff.to> Mail-Followup-To: Bruno Wolff III , LiveShell , hubert depesz lubaczewski , pgsql-admin@postgresql.org References: <928fe9b50607200226w3c9eca67h5e0e5d9a4466aeef@mail.gmail.com> <9e4684ce0607200232j5db5ddcdp8ba85ee5b212fbfa@mail.gmail.com> <928fe9b50607200241pea3a0bej11083ebd45dae8d4@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <928fe9b50607200241pea3a0bej11083ebd45dae8d4@mail.gmail.com> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200607/174 X-Sequence-Number: 22420 On Thu, Jul 20, 2006 at 15:11:35 +0530, LiveShell wrote: > hi hubert > actally i have UNIX time and that is in *1153222974* format. and i m using > C api to insert this time in a column whose type is timestamp. > so now can u tell me .... how can i convert it to timestamp and insert into > the timestamp column. Note that you should be using "timestamp with time zone" (timestamptz) for this rather than "timestamp".