Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Size of Date field
<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.