Oracle9i TIMESTAMP - an internal look

From: Hillel Eilat <hillel_at_attunity.co.il>
Date: Tue, 6 Jan 2004 13:16:44 +0200
Message-ID: <bte5gv$bd1$1@news2.netvision.net.il>

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. Received on Tue Jan 06 2004 - 05:16:44 CST