Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Size of Date field

Size of Date field

From: Jack Wang <nospam_at_nospam.com>
Date: Wed, 06 Aug 2003 06:25:34 GMT
Message-ID: <yb1Ya.40993$LD6.846165@news0.telusplanet.net>


<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.

Received on Wed Aug 06 2003 - 01:25:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US