anthony.green (1/29/2013)
Are you familiar with fractions of time?10th of a second
100th of a second
1000th of a second
etc.
Well a nano second is 1 billionth of a second.
So time is actuate to 100 billionth's of a second
Now i got clear picture, as follows:
1sec = 10^9 nanoseconds
But in sql server the time's precession is 10^7, so 10^9 - 10^7 = 10^2 (100 is the part of the nanoseconds). For example as one of our author mentioned in this chain 12.12.34.0000005 this is 000000500 (500) nanosecond. I believe it is correct.
🙂