Re: Y2k Server Testing, What's in a date?
From: Christopher Davies <mcd_at_uumin.min.net>
Date: 21 Nov 1998 18:05:21 -0500
Message-ID: <737gvh$emg$1_at_uumin.min.net>
Date: 21 Nov 1998 18:05:21 -0500
Message-ID: <737gvh$emg$1_at_uumin.min.net>
In article <6vku0s$eol$1_at_reader2.wxs.nl>,
Gert-Jan Mellema <tnalg_at_wxs.nl> wrote:
>Changing the NLS data format is not enough:
>When the number is >= 50 '19 is put before it. You can imagine what will
>happen when the legacy system at some point will start sending a order date
>having a format of yyyymmdd! The oracle application will no longer work
>correctly.
Sure it will, the code you wrote checks the length of the field as it is read in and will automatically switch when the legacy vendor fixes their code. :-) Received on Sun Nov 22 1998 - 00:05:21 CET