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

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