Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Y2K date problem - anyone help?
DAVE:
I think your database is translating the '00' to the year 1900
to make it work right.. set the following parameter in your
init.ora file and restart the database..
nls_date_format= DD-MON-RR
-Bruce Taneja
Oracle DBA
"Dave" <daveg_at_tcp.co.uk> on 11/09/99 04:07:11 PM
Please respond to "comp.databases.oracle.server_at_list.deja.com"
<comp.databases.oracle.server_at_list.deja.com>
To: "comp.databases.oracle.server_at_list.deja.com"
<comp.databases.oracle.server_at_list.deja.com>
cc:
Subject: Y2K date problem - anyone help?
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
Sent via Deja.com http://www.deja.com/ Before you buy. Received on Tue Nov 16 1999 - 16:35:08 CST