From pmp_pg@yahoo.co.in Mon Nov 25 06:45:44 2002 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A3B2F475C45 for ; Mon, 25 Nov 2002 01:45:44 -0500 (EST) Received: from web8203.mail.in.yahoo.com (web8203.mail.in.yahoo.com [203.199.70.117]) by postgresql.org (Postfix) with SMTP id 102CB475BA1 for ; Mon, 25 Nov 2002 01:45:43 -0500 (EST) Message-ID: <20021125064542.14133.qmail@web8203.mail.in.yahoo.com> Received: from [203.124.130.26] by web8203.mail.in.yahoo.com via HTTP; Mon, 25 Nov 2002 06:45:42 GMT Date: Mon, 25 Nov 2002 06:45:42 +0000 (GMT) From: =?iso-8859-1?q?Prasanna=20Phadke?= Subject: Difference in the actual and extracted values of timestamp To: pgsql-jdbc@postgresql.org Cc: pgsql-interfaces@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1504500618-1038206742=:14097" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/117 X-Sequence-Number: 3365 --0-1504500618-1038206742=:14097 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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 --0-1504500618-1038206742=:14097 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit

  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 --0-1504500618-1038206742=:14097-- From blind@xythos.com Mon Nov 25 17:22:47 2002 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 > > From john@phaedrusdeinus.org Tue Nov 26 19:38:47 2002 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