Re: Oracle9i TIMESTAMP - an internal look

Hillel Eilat wrote:

> Hi
>
> I do not manage to find a reference as to how the TIMESTAMP datatype is
> represented internally.
>
> For the "oldies" I have:
>
> type OCITime = packed record
> OCITimeHH: ub1;
> OCITimeMM: ub1;
> OCITimeSS: ub1;
> end;
> type OCIDate = packed record
> OCIDateYYYY: sb2;
> OCIDateMM: ub1;
> OCIDateDD: ub1;
> OCIDateTime: OCITime;
> end;
>
> Now - how about the the newcomers, especially TIMESTAMP:
> Where is the fractional portion reside at? The scaling factor? etc...
>
> Your assistance will be appreciated.
>
> Thanx
>
> Hillel.
>
>

SELECT dump(timestamp_field) FROM table_name;

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