Re: Stupid Dates

From: Mike Burden <michael.burden_at_capgemini.co.uk>
Date: Tue, 19 Jan 1999 10:51:06 +0000
Message-ID: <36A46399.6AACE6AA@capgemini.co.uk>

Hi Glenn.

Look for any code that converts Oracle dates to characters. If in SQL or PL/SQL look for to_char functions that have a data format or to_date functions.

Sometimes a programmer will convert a date to text to do some manipulation on it before converting it back. If the to_char or to_date contains YY instead of YYYY then there is potential for a problem.

For other programming languages (3GLs) it's more difficult because the problem may lie in the 3GL code.

Glenn Baron wrote:

> Hi all
>
> My company is belatedly about to tackle a Y2K audit and fix. Obviously we
> have little time to spare and we would be most grateful for any clues that
> might help.
>
> On of our first tasks will be to search for and eliminate 'hard-coded'
> dates. '31-Dec-99' is an obvious candidate. Has anyone come across other
> similar foolishness ?
>
> The tools involved are :
>
> Sql
> PL/Sql
> Forms 3.0 and 4.5
> RPT
> Reportwriter 2.5
>
> Any other general advice would also be most welcome :)
>
> Cheers,
>
> Glenn Baron
Received on Tue Jan 19 1999 - 04:51:06 CST