pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Difference in the actual and extracted values of timestamp
3+ messages / 3 participants
[nested] [flat]

* Difference in the actual and extracted values of timestamp
@ 2002-11-25 06:45  Prasanna Phadke <pmp_pg@yahoo.co.in>
  0 siblings, 2 replies; 3+ messages in thread

From: Prasanna Phadke @ 2002-11-25 06:45 UTC (permalink / raw)
  To: pgsql-jdbc@postgresql.org; +Cc: pgsql-interfaces


  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

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [JDBC] Difference in the actual and extracted values of timestamp
@ 2002-11-25 17:06  Barry Lind <blind@xythos.com>
  parent: Prasanna Phadke <pmp_pg@yahoo.co.in>
  1 sibling, 0 replies; 3+ messages in thread

From: Barry Lind @ 2002-11-25 17:06 UTC (permalink / raw)
  To: Prasanna Phadke <pmp_pg@yahoo.co.in>; +Cc: pgsql-jdbc@postgresql.org; pgsql-interfaces

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;
> 






^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Difference in the actual and extracted values of timestamp
@ 2002-11-26 19:24  johnnnnnn <john@phaedrusdeinus.org>
  parent: Prasanna Phadke <pmp_pg@yahoo.co.in>
  1 sibling, 0 replies; 3+ messages in thread

From: johnnnnnn @ 2002-11-26 19:24 UTC (permalink / raw)
  To: Prasanna Phadke <pmp_pg@yahoo.co.in>; +Cc: pgsql-interfaces

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2002-11-26 19:24 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-11-25 06:45 Difference in the actual and extracted values of timestamp Prasanna Phadke <pmp_pg@yahoo.co.in>
2002-11-25 17:06 ` Barry Lind <blind@xythos.com>
2002-11-26 19:24 ` johnnnnnn <john@phaedrusdeinus.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox