Re: How do I insert a BC date into Oracle?
Date: Wed, 6 Aug 2008 04:59:34 -0700 (PDT)
On Aug 6, 2:28 am, Geoff Muldoon <geoff.muld..._at_trap.gmail.com> wrote:
> 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?
That's Julian date 0000001.
David Fitzjarrell Received on Wed Aug 06 2008 - 06:59:34 CDT