Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Y2K date problem - anyone help?
try to change dd-mon-yy date format to dd-mon-rr
may be this will help
feherl
Dave wrote in message <382889de.430615_at_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 Wed Nov 10 1999 - 03:19:12 CST