Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A8C2F476CE4 for ; Tue, 26 Nov 2002 14:38:47 -0500 (EST) Received: from phaedrusdeinus.org (dsl092-130-239.chi1.dsl.speakeasy.net [66.92.130.239]) by postgresql.org (Postfix) with SMTP id 34D8347612B for ; Tue, 26 Nov 2002 14:23:51 -0500 (EST) Received: (qmail 55253 invoked by uid 1001); 26 Nov 2002 19:24:24 -0000 Date: Tue, 26 Nov 2002 13:24:24 -0600 From: johnnnnnn To: Prasanna Phadke Cc: pgsql-interfaces@postgresql.org Subject: Re: Difference in the actual and extracted values of timestamp Message-ID: <20021126192423.GC54691@performics.com> References: <20021125064542.14133.qmail@web8203.mail.in.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20021125064542.14133.qmail@web8203.mail.in.yahoo.com> User-Agent: Mutt/1.5.1i X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/119 X-Sequence-Number: 3367 On Mon, Nov 25, 2002 at 06:45:42AM +0000, Prasanna Phadke wrote: > While I tried to extract the the information of timestamp, I am > getting 3.30 hrs difference to the value which is actually in the > database. I am using JDBC1.3.1_02 and using pgjdbc2.jar as a JDBC > driver. Sounds like a timezone issue to me. Are you perhaps in a timezone which is 3:30 offset from GMT? -johnnnnnnnn