Re: How do I insert a BC date into Oracle?
Date: Wed, 6 Aug 2008 17:28:29 +1000
> 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)
Does anyone know why they picked 4712 BC? Received on Wed Aug 06 2008 - 02:28:29 CDT