Re: Y2K Problem and Oracle 7.3

From: Dominique Potter <dom_at_cheerful.com>
Date: Wed, 8 Jul 1998 10:04:30 +0100
Message-ID: <6nvc4j$8f9$1@nclient3-gui.server.virgin.net>

Ooops, sorry, I missed out the fourth 'R' in my message. Using the 'DD-MM-RRRR' works fine for me if I insert a short date into the database. My client app is *incorrectly* passing back a full century date (with the wrong century e.g. I input a '2001' and the app passes back a '1901'). I need to force oracle to insert a '20XX' when the date is between 1900<>1950.

> Dom_at_cheerful.com
>
>Use 'DD-MM-RRRR'. You only had 3 R's rather than 4. I use
>this mask with 7.3.3 in several applications with no problem
>using century or not.
>
>MR.
Received on Wed Jul 08 1998 - 04:04:30 CDT