Re: [JDBC] Difference in the actual and extracted values of timestamp

From: Barry Lind <blind(at)xythos(dot)com>
To: Prasanna Phadke <pmp_pg(at)yahoo(dot)co(dot)in>
Cc: pgsql-jdbc(at)postgresql(dot)org, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: [JDBC] Difference in the actual and extracted values of timestamp
Date: 2002-11-25 17:06:15
Message-ID: 3DE25887.3080000@xythos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces pgsql-jdbc

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
> <http://in.sports.yahoo.com/cricket/tracker.html>
>

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Bruce Momjian 2002-11-25 22:39:20 pgperl 2.0 released
Previous Message Carlos Amaral 2002-11-25 11:20:46 unsubscribe

Browse pgsql-jdbc by date

  From Date Subject
Next Message Fernando Nasser 2002-11-26 15:37:22 Re: forName finds Driver but getConnection doesn't
Previous Message Pedro Salazar 2002-11-25 16:25:25 Re: CallableStatements support: when?