ORACLE Date Ranges & Y2K Bug
From: <dloper_at_my-dejanews.com>
Date: Thu, 17 Dec 1998 02:06:32 GMT
Message-ID: <759ov7$jt2$1_at_nnrp1.dejanews.com>
[Quoted] I am working on some reports that have user defined date ranges. I am trying to Y2K proof them. I have succeeded in using the MM/DD/RR date format. I can get the data when the date ranges are within the same century.
Date: Thu, 17 Dec 1998 02:06:32 GMT
Message-ID: <759ov7$jt2$1_at_nnrp1.dejanews.com>
[Quoted] I am working on some reports that have user defined date ranges. I am trying to Y2K proof them. I have succeeded in using the MM/DD/RR date format. I can get the data when the date ranges are within the same century.
Example:
From Date: 12/01/1998 To Date: 12/31/1999 From Date: 01/01/2000 To Date: 01/31/2001 These date ranges work fine. The problem developes when I input a date range in like the following: From Date: 12/01/1998 To Date: 01/31/2001
The program can't find the transactions when I cross the into the year 2000 from the 1900's.
Has anyone ever come up against this problem? I would appreciate any help you can give.
Thanks
Diane
Dloper_at_cyberzone.net
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Dec 17 1998 - 03:06:32 CET