Postgres Pro
Downloads
Home   >   mailing lists

Re: Difference in the actual and extracted values of timestamp - Mailing list pgsql-jdbc

From Barry Lind
Subject Re: Difference in the actual and extracted values of timestamp
Date
Msg-id 3DE25887.3080000@xythos.com
Whole thread Raw
In response to Difference in the actual and extracted values of timestamp  (Prasanna Phadke <pmp_pg@yahoo.co.in>)
List pgsql-jdbc
Tree view 
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>
>

pgsql-jdbc by date:

Previous
From: Pedro Salazar
Date:
Subject: Re: CallableStatements support: when?
Next
From: Fernando Nasser
Date:
Subject: Re: forName finds Driver but getConnection doesn't