Re: Size of Date field

From: Lucyna Witkowska <ypwitkow_at_nospamcyf-kr.edu.pl>
Date: Wed, 6 Aug 2003 08:30:03 +0000 (UTC)
Message-ID: <bgqeab$r1k$2@srv.cyf-kr.edu.pl>

Jack Wang <nospam_at_nospam.com> wrote:
> <Quotes from docs>
> Oracle uses its own internal format to store dates. Date data is stored in
> fixed-length fields of seven bytes each, corresponding to century, year,
> month, day, hour, minute, and second.
> </Quotes>

> SQL>select length(bday) from t;

> returns length of 9 instead of 7. Can someone explain it? Thanks.

It returns 8. One additional byte for length od data. Greetings,
LW Received on Wed Aug 06 2003 - 03:30:03 CDT