Re: oracle timestamp internal storage and precision

My discussion was based on datatype TIMESTAMP.

If OP is asking about SCN, a different scenario applies than what I answered.

Then again, SCN does not correspond to date/time, and only uses a mapping to assist in approximating a linkage between date/time and SCN number.

/Hans

On 19/12/2012 12:07 PM, Tim Gorman wrote:
> When you say "internal timestamp" and "number", are you referring to
> DATE and TIMESTAMP data types, or are you referring to the SCN (i.e.
> system change number) used internally within the RDBMS as a relative
> timestamp? The wording of the question could go either way...
>

--
http://www.freelists.org/webpage/oracle-l