Re: Year 2000 ?

From: Andrew Babb <andrewb_at_mail.com>
Date: Wed, 31 Mar 1999 23:49:51 +0800
Message-ID: <3702441E.C10E927E@mail.com>

Check below.

Andrew

Kurien Baby wrote:

> Hi
>
> I would like to get some feed backs, since i am very new to Oracle
> world.
>
> 1. If Datatype is 'date' and no date is stored in the field, how is the
> datae acutally stored in Oracle? As nulls or Zeroes? This will happen
> for field which are not 'required' in order to write a record.

Any column that holds no data is stored as NULL's and therefore data is not written to this particular column. Also, remember that the predicate is COL1 is NULL for checking a NULL.

>
>
> 2. How is the date in Oracle actually stored? Are they represented as an
> offset from a base date/time?

Dates are stored as a 7 byte number, with the offset from somewhere in 4000BC running through to 4000AD.

>
>
> I would appriciate your help.
>
> thanks
>
> Kurien
>
> kbaby_at_newbridge.com
Received on Wed Mar 31 1999 - 09:49:51 CST