Max Date
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Max Date

  1. #1
    Join Date
    Nov 2001
    Posts
    118

    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

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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

  4. #4
    Join Date
    Jan 2003
    Location
    Arlington, VA
    Posts
    1
    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?

  5. #5
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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

  6. #6
    Join Date
    Nov 2001
    Posts
    118
    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
  •  


Click Here to Expand Forum to Full Width