Re: TIMESTAMP internal structure

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Thu, 13 Apr 2006 10:06:49 +0200
Message-ID: <e1l0qk$5of$00$1@news.t-online.com>

Mark D Powell schrieb:
> Interesting question to which I do not know the answer and am mainly
> posting so that if someone does I will catch it.
>
> What I do know is that a timestamp datatype takes 11 bytes of storage
> and a timestamp with time zone 13. The OCI information on
> OCCI_SQLT_TIMESTAMP might be of interest.
>
> What you could do is create a table with just a few rows of timestamp
> data and dump the blocks. You could also try the dump() function on a
> timestamp. I will have to put doing these things on my list of things
> to try.
>
> HTH -- Mark D Powell --
>

In Tom Kytes last book he writes about it, the data structure is identical to the date type with additional 4 bytes for the fractional seconds ( it is generally very good chapter about the datatypes in oracle ).

Best regards

Maxim Received on Thu Apr 13 2006 - 03:06:49 CDT