Y2K date problem - anyone help?

From: Dave <daveg_at_tcp.co.uk>
Date: Tue, 09 Nov 1999 21:07:11 GMT
Message-ID: <382889de.430615@news.tcp.co.uk>

Hi everyone,

I have a little problemette. We are currently using Oracle 7.1.3 and all our date fields are held in the format dd-mon-yy.

I have recently found some sql that isn't y2k friendly, here goes:

SELECT * FROM delivery WHERE delivery_due_date > &P_from_date AND delivery_due_date < &P_to_date

Okay, if '02-dec-99' is entered for parameter &P_from_date and '31-dec-99' for &P_to_date then I get the results I expect, ie, all deliveries due between the two dates. However, if I use '02-dec-99' and '02-jan-00' then I get no rows selected when in reality I should get some.

Is there some way I can get this to work using to_char maybe?

Any help is appreciated.

Dave Received on Tue Nov 09 1999 - 15:07:11 CST