Re: How do I insert a BC date into Oracle?

From: Geoff Muldoon <>
Date: Wed, 6 Aug 2008 17:28:29 +1000
Message-ID: <>

Murali says...
> 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.

You can't. The Oracle date data type only goes back to 4712 BC

And it should be inserted using a proper format mask, eg.:

INSERT INTO some_table(some_date_field)
VALUES(TO_DATE('-4712/01/01', 'syyyy/mm/dd'));

Geoff M

Does anyone know why they picked 4712 BC? Received on Wed Aug 06 2008 - 02:28:29 CDT

Original text of this message