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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces pgsql-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

Browse pgsql-interfaces by date

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

Browse pgsql-jdbc by date

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