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

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