Re: Year 2000 Insert Statement

insert into <tablename> values (to_date('01-jan-00','dd-mon-rr'));

you can use other variations of the date format but RR is Oracle's Y2K date mask. Other examples would be 'ddmmrr' , 'dd/mon/rr' , etc...

Good luck , Robert Prendin Received on Wed Mar 18 1998 - 00:00:00 CST