-
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.
Jeff Hunter
-
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.
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
-
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.
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|