Re: oracle timestamp internal storage and precision
- From: Hans Forbrich <fuzzy.graybeard@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 19 Dec 2012 13:18:46 -0700
Good point.
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...
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
