Max Date

Hi, Can anyone tell me which is the largest date I can insert into a table in Oracle 8.1.7.?
Thanks
Peer

to_date(Forever)

no wait, to_date(Forever+1)

no wait, to_date(Forever+2)

In other words, you can put any date you can dream up.

8i concepts manual say:
"Oracle can store dates in the Julian era, ranging from January 1, 4712 BCE through December 31, 4712 CE (Common Era)."
Should be OK for accountants and insurance agents, but tough on archeologists.

9i should be able to handle dates all the way up to December 31st, 9999AD. I guess in about 8000 years we might have a Y10K bug? :)

I'm offering consultancy services for Y4.7K and Y10K - payment in advance.

Thanks very much, everyone.
It seems that 31.12.9999 is the upper limit.
I'll get back to you on the Y10K problem
Bye Peer