+ Reply to Thread
Results 1 to 6 of 6

Thread: Max Date

  1. 01-22-2003 11:52 AM #1
    Peer Jones
    Peer Jones is offline Member
    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
    Reply With Quote Reply With Quote
  2. 01-22-2003 11:55 AM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,094
    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."
    Reply With Quote Reply With Quote
  3. 01-22-2003 12:18 PM #3
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    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
    Reply With Quote Reply With Quote
  4. 01-22-2003 01:16 PM #4
    whitebread2
    whitebread2 is offline Junior Member
    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?
    Reply With Quote Reply With Quote
  5. 01-23-2003 02:41 AM #5
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    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
    Reply With Quote Reply With Quote
  6. 01-23-2003 03:31 AM #6
    Peer Jones
    Peer Jones is offline Member
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

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