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

Re: Date problem on Aix jdk1.4.1

From: "Byron Nikolaidis" <ByronN(at)Routescape(dot)com>
To: "Oliver Jowett" <oliver(at)opencloud(dot)com>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Date problem on Aix jdk1.4.1
Date: 2005-07-28 03:06:53
Message-ID: 6E0907A94904D94B99D7F387E08C4F570732F3@FALCON.INSIGHT (view raw or flat)
Thread:
Lists: pgsql-jdbc
Thanks Oliver!    The driver you sent me worked correctly on aix!

Is there a plan for an official (or somewhat official) driver release
soon?

Byron

Parsed date '2005-07-26' in zone America/New_York as 2005-07-26 AD
00:00:00 -0400 (millis=1122350400000)
id=1, effective=1122350400000
Parsed date '2005-07-26' in zone America/New_York as 2005-07-26 AD
00:00:00 -0400 (millis=1122350400000)
id=2, effective=1122350400000
Parsed date '2005-07-26' in zone America/New_York as 2005-07-26 AD
00:00:00 -0400 (millis=1122350400000)
id=3, effective=1122350400000

-----Original Message-----
From: Oliver Jowett [mailto:oliver(at)opencloud(dot)com] 
Sent: Wednesday, July 27, 2005 8:24 PM
To: Byron Nikolaidis
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] Date problem on Aix jdk1.4.1

Byron Nikolaidis wrote:
> Timezone on AIX box is EDT (you can see Calendar below too).  
> 
> As for the Calendar output,  the values on AIX between rows is
identical
> (except for the time=1122350400000).      To compare AIX and Windows,
I
> see a single difference: on Windows the DAY_OF_YEAR=365 compared with
> AIX DAY_OF_YEAR=?,  not sure if that means anything?

Not sure; 365 is certainly wrong though.

I also see a slight difference in the timezone info (transitions=139 vs.
transitions=235) but I don't think that should cause any difference in
theory.

> Can anybody run this test on Aix 5.3, either to confirm they get the
> same behavior, or use Java 1.4.2 and verify everything works fine?

Hm, I can only guess that it's some difference in Calendar behaviour
between 1.4.1 and 1.4.2 then..

I'll send you a build of the driver with my pending timestamp changes
included -- there are lots of changes in the date parsing area and I'm
interested whether they change the behaviour you see or not.

-O

Responses

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2005-07-28 03:49:28
Subject: Re: Date problem on Aix jdk1.4.1
Previous:From: Oliver JowettDate: 2005-07-28 00:24:16
Subject: Re: Date problem on Aix jdk1.4.1

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