Re: Date Format Problem/Internal Date Storage

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Sat, 27 Jan 2001 22:29:35 GMT
Message-ID: <jZHc6.323209$U46.10063825@news1.sttls1.wa.home.com>

What are you passing in as a valid date? What is your date format? Are you specifying 4 digits for the year or 2?
Jim

"SBumford" <sbumford_at_aol.com> wrote in message news:20010127165624.10139.00001316_at_ng-cr1.aol.com...
> Hi all,
>
> I have just experienced a problem with invalid inserted dates in Oracle.
>
> Using the dump statement on the date field in my table, I found that the
year
> byte is 201, whereas I was expecting this to be 101.
>
> I am using a Prepared Statement using JDBC. My conclusion is that the
problem
> is to do with the version of classes111.zip (Oracle JDBC driver classes)
which
> uses the OCI73JDBC.DLL.
>
> The only problem is that I cannot find any documentation of whether this
is a
> bug to do with the above.
>
> I have validated the date that I am passing, but what concerns me most is
the
> fact that the year byte should never be greater than 199, whereas I'm
getting
> 201.
>
> Any knowledge about the problem.
>
> TIA,
>
> Stephen
Received on Sat Jan 27 2001 - 16:29:35 CST