please test on 8i

From: Analysis&Solutions <info_at_analysisandsolutions.com>
Date: Mon, 15 Dec 2003 07:00:32 +0000 (UTC)
Message-ID: <brjm6g$rtq$1@reader2.panix.com>

Greetings:

I have access to a Oracle 9.2 server. The following queries run fine. Can someone with access to a machine with some 8i version on it please give the following a test and let me know what, if any, errors are produced and which version you're using?

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS'; CREATE TABLE tbl (col date default '2041-01-21');

insert into tbl values (default);
insert into tbl values ('2042-02-22');
insert into tbl values ('9999-12-31');

select * from tbl;
drop table tbl;

Thank you,

--Dan
--

     FREE scripts that make web and database programming easier
           http://www.analysisandsolutions.com/software/

 T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y  4015 7th Ave #4AJ, Brooklyn NY v: 718-854-0335 f: 718-854-0409 Received on Mon Dec 15 2003 - 01:00:32 CST