Re: ORACLE Data Ranges/Y2k Bug

From: Mark Powell <Mark.Powell_at_eds.com>
Date: 17 Dec 1998 14:37:14 GMT
Message-ID: <01be29cb$12640fc0$a12c6394@J00679271.ddc.eds.com>

Diane, you need to post some SQL that does not work. I am pretty sure developers here have been able to find data that spans the century, but it does depend on how you write your code.

dloper_at_my-dejanews.com wrote in article <759orm$jpv$1_at_nnrp1.dejanews.com>...
> 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 - 08:37:14 CST