Thread: [BUG?] Extreme dates

pg 7.4.2
pgjdbc driver version 213

Hi,

1) It appears that when saving 10/30/0002 (yes, 0002), the jdbc driver saves it
as 02/11/2030.

2) May I suggest including version of the jdbc driver in the jar's
META-INF/MANIFEST.MF file? Jars get renamed, etc but manifest always stays the
same. There's Ant task for populating manifest properties.

Thanks












__________________________________
Do you Yahoo!?
SBC Yahoo! - Internet access at a great low price.
http://promo.yahoo.com/sbc/

On Sun, 16 May 2004, ow wrote:

> pg 7.4.2
> pgjdbc driver version 213
>
> Hi,
>
> 1) It appears that when saving 10/30/0002 (yes, 0002), the jdbc driver
> saves it as 02/11/2030.

I've tried to duplicate this and have failed.  It does appear that Java is
doing something strange with the date, changing it to 11/30/0002, but I
don't understand why, and that has nothing to do with the JDBC driver or
the database.  How are you constructing the date value to insert?  Please
try the attached test and see what changes are necessary to get the
failure you describe.

>
> 2) May I suggest including version of the jdbc driver in the jar's
> META-INF/MANIFEST.MF file? Jars get renamed, etc but manifest always
> stays the same. There's Ant task for populating manifest properties.
>

The seems like a reasonable thing to do.  You can currently determine the
version info from a randomly named pg jdbc jar file by using
org.postgresql.Driver.getVersion(), but that essentially requires writing
a dummy program to do so.

Kris Jurka

Save that date as Char

----- Original Message -----
From: "ow" <oneway_111@yahoo.com>
To: <pgsql-jdbc@postgresql.org>
Sent: Sunday, May 16, 2004 12:02 PM
Subject: [JDBC] [BUG?] Extreme dates


> pg 7.4.2
> pgjdbc driver version 213
>
> Hi,
>
> 1) It appears that when saving 10/30/0002 (yes, 0002), the jdbc driver
saves it
> as 02/11/2030.
>
> 2) May I suggest including version of the jdbc driver in the jar's
> META-INF/MANIFEST.MF file? Jars get renamed, etc but manifest always stays
the
> same. There's Ant task for populating manifest properties.
>
> Thanks
>
>
>
>
>
>
>
>
>
>
>
>
> __________________________________
> Do you Yahoo!?
> SBC Yahoo! - Internet access at a great low price.
> http://promo.yahoo.com/sbc/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>