'Date' datatype question

I've got a date datatype. I defined it at 'date' during creation of tables.

Basically, I want to be able to be y2k compliant therefore, want to be able to handle 4 digit years.

#1: How do I get it to take "10-Jan-1998" instead of "10-Jan-98" ?

#2: Do I even have to worry about that at all, i.e. Oracle 7 already takes all
years and stores as 4 digit yrs.

#3: If so, entering "10-Jan-00" will make sense and after input, doing an order
will show "00" as the latest year.

Any help would be appreciated, pls respond via email: sevirina_at_aol.com

Thanks Received on Sat Nov 29 1997 - 00:00:00 CST