How do I insert a BC date into Oracle?

From: Murali <feedback2murali_at_gmail.com>
Date: Tue, 5 Aug 2008 23:21:18 -0700 (PDT)
Message-ID: <1b5d3e78-517a-4b89-aac0-e603a4b9f82b@i20g2000prf.googlegroups.com>

Hi,

Let's say I want to insert 104000 BC into a date field in an Oracle table? How do I do that? Is it as simple as inserting "-104000" into the date field or is it more complex than that?

Any help would be appreciated.

-Murali Received on Wed Aug 06 2008 - 01:21:18 CDT

This message: [ Message body ]
Next message: Geoff Muldoon: "Re: How do I insert a BC date into Oracle?"
Previous message: artmerar_at_yahoo.com: "Re: Can this be done with a trigger?"
Next in thread: Geoff Muldoon: "Re: How do I insert a BC date into Oracle?"
Reply: Geoff Muldoon: "Re: How do I insert a BC date into Oracle?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message