Postgres Pro
Downloads
Home   >   mailing lists

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

From johnnnnnn
Subject Re: Difference in the actual and extracted values of timestamp
Date
Msg-id 20021126192423.GC54691@performics.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-interfaces
Tree view 
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

pgsql-interfaces by date:

Previous
From: Artur Trzewik
Date:
Subject: pgtcl has no coresponding function to PQcmdTuples
Next
From: Gerhard Hintermayer
Date:
Subject: Re: pgtcl has no coresponding function to PQcmdTuples