Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 46A1E475AD7; Mon, 25 Nov 2002 12:22:47 -0500 (EST) Received: from mail.xythos.com (sdsl-216-36-77-241.dsl.sjc.megapath.net [216.36.77.241]) by postgresql.org (Postfix) with ESMTP id EE421475A71; Mon, 25 Nov 2002 12:22:43 -0500 (EST) Received: from ravms by mail.xythos.com with mail-ok (Exim 3.36 #3) id 18GN4P-0000rF-00; Mon, 25 Nov 2002 17:30:53 +0000 Received: from sdsl-216-36-77-241.dsl.sjc.megapath.net ([216.36.77.241] helo=xythos.com) by mail.xythos.com with asmtp (Exim 3.36 #3) id 18GN4P-0000r4-00; Mon, 25 Nov 2002 17:30:53 +0000 Message-ID: <3DE25887.3080000@xythos.com> Date: Mon, 25 Nov 2002 09:06:15 -0800 From: Barry Lind User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.1) Gecko/20020826 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Prasanna Phadke Cc: pgsql-jdbc@postgresql.org, pgsql-interfaces@postgresql.org Subject: Re: [JDBC] Difference in the actual and extracted values of timestamp References: <20021125064542.14133.qmail@web8203.mail.in.yahoo.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Envelope-To: pmp_pg@yahoo.co.in, pgsql-jdbc@postgresql.org, pgsql-interfaces@postgresql.org X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/113 X-Sequence-Number: 3361 Prasanna, Are you sure you are comparing the two values in the same timezone. Can you send a simple test program that reproduces the problem? Also have you tried the 7.3 driver to see if the problem still exists with the latest code? thanks, --Barry 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. > > What is the problem? > > > > > > Catch all the cricket action. Download Yahoo! Score tracker > >