Re: Oracle DATE datatype storage.

In article <3v0gi8$cv1_at_helios.vanderbilt.edu>, Randy Fought <FOUGHTRL_at_CTRVAX.VANDERBILT.EDU> writes:
> Internally Oracle stores the DATE datatype in seven bytes.
> One byte for each of the century, year, month, day, hour, minute
> and second.
>
> We don't care about the hour, minute and second and we have
> many dates to store. This seems quite wasteful to store this in
> seven bytes when it could be done in four. Is there a way to internally
> store the date in four bytes?
>
> Randy
your best bet is to store it as a NUMBER(8) YYYYMMDD
instead of using the ORACLE date format.

M.diTommaso
ditommaso_at_ebi.ac.uk Received on Tue Jul 25 1995 - 00:00:00 CEST