Oracle Date 10000-01-01

[KY.Chuang]

Hi,
According I knew, Oracle date range is between -4713 and +9999.
Is it possible that Oracle store the vaule : 10000/1/1 of date format in Oracle
Database.
Becuase I saw this value in my data using DBA Studio.
and my application insert this kinds of value into Oracle Database.
From Databse, I got this vaule(10000/1/1) from table field of date format.

Oracle Version : 8.0,5

Thanks & Regards.

K.Y

[Marcel Boogert_1]

Hi there,

if question=oracle
exec metalink.oracle.com
fi

MB.

[Steven E. Protter]

Your back end database is old, but from what you report, the back end database handles five digit years. They probably fixed it when they dealt with Y2K

SEP

[Yogeeraj_1]

hi,

metalink according to note:217143.1, says
date datatype:
range from January 1, 4712 BC to December 31, 9999 AD

the cases that you might have observed is most probably a BUG!

hope this helps!

regards
Yogeeraj

[Eric Antunes]

Hi,

I'm not sure to understand your question but there is no way that you can get this value for the year (at least on a 8.0.5). Because you cannot insert this kind of value, you also cannot get one.

For better understanding, see the explanation for the following error:

"ORA-01841: (full) year must be between -4713 and +9999

Cause: A date specified a year that is not in the valid date range. A valid date is any date between January 1, 4712 B.C. and December 31, 4712 A.D.

Action: Enter a valid date value between 4712 B.C. and 4712 A.D."


Best Regards,

Eric Antunes

[KY.Chuang]

Dear all,
Actually, this kinds of value really exist.
and It's not a bog of Oracle.
Please check the attachment...

Regards.
K.Y

[Yogeeraj_1]

hi,

still looking like a bug in the tool you are using to query the data.

can you post the output of:
select max(t$exdt) from ttiedm100886;


regards
Yogeeraj

[KY.Chuang]

to Yogeeraj,
select max(t$exdt) from ttiedm100886 ;
output data is : 2099/12/31

...
else
Can you give me a sample syntax to export a Table structure and data.
and I will post it to this thread.

K.Y

[KY.Chuang]

to Yogeeraj,
Please check following sql and result,
SQL> select min(t$exdt) from baan.ttiedm100886;
MIN(T$EXDT)
------------
01-JAN-99

SQL> select max(t$exdt) from ttiedm100886;
MAX(T$EXDT)
------------
31-DEC-99

SQL> select min(to_char(T$EXDT, 'YYYY/MM/DD')) from ttiedm100886;

MIN(TO_CHA
----------
0000/00/00

K.Y

[Yogeeraj_1]

hi K.Y,

can you post the SQLPLUS output of:
describe ttiedm100886

The last sql output look really intriguing!

thanks
Yogeeraj