Skip site navigation (1) Skip section navigation (2)

Re: Difference in the actual and extracted values of timestamp

From: johnnnnnn <john(at)phaedrusdeinus(dot)org>
To: Prasanna Phadke <pmp_pg(at)yahoo(dot)co(dot)in>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Difference in the actual and extracted values of timestamp
Date: 2002-11-26 19:24:24
Message-ID: 20021126192423.GC54691@performics.com (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-jdbc
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

In response to

pgsql-interfaces by date

Next:From: Gerhard HintermayerDate: 2002-11-26 19:43:03
Subject: Re: pgtcl has no coresponding function to PQcmdTuples
Previous:From: Gerhard HintermayerDate: 2002-11-26 17:34:22
Subject: still memory leaks with libpgtcl

pgsql-jdbc by date

Next:From: Nic FerrierDate: 2002-11-26 21:20:56
Subject: Re: streaming result sets: progress
Previous:From: Dave CramerDate: 2002-11-26 17:11:51
Subject: Re: by the way...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group