Re: Valid Dates in Oracle

From: Scott Mattes <smattes_at_INTERSERF.NET>
Date: Sat, 3 Feb 1996 11:22:52 +0000
Message-Id: <9602031627.AA13955@alice.jcc.com>

> Date: Fri, 2 Feb 1996 18:02:58 -0800
> Reply-to: "ORACLE database mailing list." <ORACLE-L_at_CCVM.SUNYSB.EDU>
> From: jfm <jfm_at_PA.MICROSERVE.COM>
> Subject: Valid Dates in Oracle
> X-To: ORACLE-L_at_ccvm.sunysb.edu
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_CCVM.SUNYSB.EDU>

> Can I use the dates of 01-01-0001 or 12-31-9999 in an oracle date field?
> (These are common defaults we use in DB2).
> Thanks.

Jim,
  I tried both and 0001 goes in, 9999 is out of range (-4731 to +4731 I think it said were valid). I tried selecting the 0001 and it displays in default dd-mon-yy format, but when I try to convert it to yyyy I get 'invalid' number.
> Database Analyst
> PA Blue Shield
> JFM_at_pa.microserve.com
>
>

---

Scott Mattes
I-Net, Inc.

We are free to choose what we will do, think, say, be, but we are not free to choose the consequences of those choices. Received on Sat Feb 03 1996 - 11:27:21 CST