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

Re: Date problem on Aix jdk1.4.1

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Byron Nikolaidis <ByronN(at)Routescape(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Date problem on Aix jdk1.4.1
Date: 2005-07-27 22:59:11
Message-ID: 42E811BF.3010005@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Byron Nikolaidis wrote:

> When I query any table with a regular old Date in it,  the first row
> that comes back is correct (some Date value with 00:00:00 as the time) ,
> however all subsequent rows are advanced by 1 hour (they have a time of
> 01:00:00) .    This happens on any table. 

It's quite weird that it's different on the first row, otherwise I'd say
it was a local JVM timezone issue.

Do you have some test code we can try? Without knowing what the
underlying column's type is or which ResultSet accessor you're using
it's just guesswork.

-O

In response to

pgsql-jdbc by date

Next:From: Vadim NasardinovDate: 2005-07-27 23:00:39
Subject: Re: jdbc xa patches
Previous:From: Byron NikolaidisDate: 2005-07-27 22:51:17
Subject: Date problem on Aix jdk1.4.1

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