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 2EBFF9FA502 for ; Thu, 20 Jul 2006 06:32:56 -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 38128-03 for ; Thu, 20 Jul 2006 09:32:48 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.190]) by postgresql.org (Postfix) with ESMTP id EAC499FA5CD for ; Thu, 20 Jul 2006 06:32:47 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id l23so428608nfc for ; Thu, 20 Jul 2006 02:32:45 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=kcN2T2vyRxadNvtj+SPkmGQuqy595sa9mUX+eaq5fusW567R8CVKkQ3ILQKgvoE9U37Y89O4i0G4rMMS+fbh+omQsfvesLk68QHXWrqPxzigkCwdYGUy8k40lCYTZOjukTmltV5+rQH//yKuadJ4rSjxt/b5PaHKbZkFj/39NuY= Received: by 10.48.108.19 with SMTP id g19mr395777nfc; Thu, 20 Jul 2006 02:32:45 -0700 (PDT) Received: by 10.48.230.20 with HTTP; Thu, 20 Jul 2006 02:32:45 -0700 (PDT) Message-ID: <9e4684ce0607200232j5db5ddcdp8ba85ee5b212fbfa@mail.gmail.com> Date: Thu, 20 Jul 2006 11:32:45 +0200 From: "hubert depesz lubaczewski" To: LiveShell Subject: Re: biginteger to timestamp Cc: pgsql-admin@postgresql.org In-Reply-To: <928fe9b50607200226w3c9eca67h5e0e5d9a4466aeef@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_70110_298644.1153387965883" References: <928fe9b50607200226w3c9eca67h5e0e5d9a4466aeef@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/164 X-Sequence-Number: 22410 ------=_Part_70110_298644.1153387965883 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline On 7/20/06, LiveShell wrote: > > Hi all, > I want to convert biginteger and integer data type to timestamp > data type. > Can any body tell me how to convert?? > and what is in this biginteger? is it something like: 20060720113254::bigint or rather something like "seconds from epoch"? or something totally different? depesz -- http://www.depesz.com/ - nowy, lepszy depesz ------=_Part_70110_298644.1153387965883 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On 7/20/06, LiveShell <liveshell@gmail.com> wrote:
Hi all,
         I want to convert biginteger and integer data type to timestamp data type.
Can any body tell me how to convert??

and what is in this biginteger?
is it something like:
20060720113254::bigint
or rather something like "seconds from epoch"?
or something totally different?

depesz

--
http://www.depesz.com/ - nowy, lepszy depesz ------=_Part_70110_298644.1153387965883--