Re: ORACLE Date Ranges & Y2K Bug

In article <759ov7$jt2$1_at_nnrp1.dejanews.com>, dloper_at_my-dejanews.com () wrote:

> 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
>
The idea of 'RR' is to avoid entering the century, so 12/01/98 refers to 1998 and 01/31/01 refers to 2001. If you really want to add 2001 then the format should be 'YYYY'

Dave Lane (dlane_at_pt.lu) Received on Sun Dec 20 1998 - 22:48:34 CET