Thread: Difference in the actual and extracted values of timestamp

Difference in the actual and extracted values of timestamp

From
Prasanna Phadke
Date:

  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

Re: Difference in the actual and extracted values of timestamp

From
johnnnnnn
Date:
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