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 1DDA99FA5F0 for ; Thu, 20 Jul 2006 06:41:42 -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 52066-10 for ; Thu, 20 Jul 2006 06:41:38 -0300 (ADT) 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 4E9A39FA5CD for ; Thu, 20 Jul 2006 06:41:38 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id l23so430466nfc for ; Thu, 20 Jul 2006 02:41:36 -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=oBVPoRw7WT5u8PpToxHxhAwgYiqtwOkOecnPG/3ZyCH/QLf0IsccC7/afxLSxIMgTNo0/8dk3tKLYU1J3vba8hdM0BaM2CUtZelvBS/IVVpcGYjyZII6iqVu5uLXQFFFlLlWjiyq86GG8jVyT6+34Y+1ESGPcAEc3XtA81UgzQk= Received: by 10.49.8.15 with SMTP id l15mr296324nfi; Thu, 20 Jul 2006 02:41:35 -0700 (PDT) Received: by 10.48.199.7 with HTTP; Thu, 20 Jul 2006 02:41:35 -0700 (PDT) Message-ID: <928fe9b50607200241pea3a0bej11083ebd45dae8d4@mail.gmail.com> Date: Thu, 20 Jul 2006 15:11:35 +0530 From: LiveShell To: "hubert depesz lubaczewski" Subject: Re: biginteger to timestamp Cc: pgsql-admin@postgresql.org In-Reply-To: <9e4684ce0607200232j5db5ddcdp8ba85ee5b212fbfa@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_17740_15871044.1153388495919" References: <928fe9b50607200226w3c9eca67h5e0e5d9a4466aeef@mail.gmail.com> <9e4684ce0607200232j5db5ddcdp8ba85ee5b212fbfa@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/165 X-Sequence-Number: 22411 ------=_Part_17740_15871044.1153388495919 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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. On 7/20/06, hubert depesz lubaczewski wrote: > > 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_17740_15871044.1153388495919 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
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.

 
On 7/20/06, hubert depesz lubaczewski <depesz@gmail.com> wrote:
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_17740_15871044.1153388495919--