Re: Date problems

From: rob <rob_at_dsdelft.nl>
Date: Wed, 10 Oct 2001 09:55:32 +0200
Message-ID: <9q0ut6$dk$1@news.tudelft.nl>

> Hi
>
> I am working under Oracle version 7.3 and i have a table containing a date
> field.
> Since year 2000, all records with an year 99 are interpreted 2099 inspite
of
> 1999.
> Can i resolve this problem ??
> If yes where in Oracle must i do the modification ??

Dates don't contain 99 as the year (unless you really mean 99 AC). You are having problem with the conversion of a string (99) to a date. If only two positions are specified it is converted to a date in the current century. Use the appropriate date format.
Please be more specific if you need more help.

Rob. Received on Wed Oct 10 2001 - 02:55:32 CDT