Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: please test on 8i

Re: please test on 8i

From: Steve Ashmore <sashmore_at_neonramp.com>
Date: Mon, 15 Dec 2003 16:05:31 -0600
Message-ID: <vtsc1q92vup135@corp.supernews.com>


Oops should have sent them all sorry. Here is the rest

SQL> insert into tbl values ('2042-02-22');

1 row created.

SQL> insert into tbl values ('9999-12-31');

1 row created.

SQL> select * from tbl;
COL



2042-02-22 00:00:00
9999-12-31 00:00:00

Steve

"Analysis&Solutions" <info_at_analysisandsolutions.com> wrote in message news:brjm6g$rtq$1_at_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 - 16:05:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US