Re: Size of Date field

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

LENGTH is meaningless. Try instead:

SELECT dump(created)
FROM user_objects
WHERE rownum < 5;

-- 
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)