Christian Smith wrote: > If you use the julianday representation, the integer component is the > number of days since "noon in Greenwich on November 24, 4714 B.C", with > the fractional part being the fraction of that day. Hence, the > resolution is determined by the fractional component of the real number. > Now, in the UK, I get the following: > sqlite> select julianday('now'); > 2454295.1407767 > > The integer component consumes probably 21 bits of the available 52 bits > mantissa of an IEEE-754 64-bit real. That leaves 31 bits for the > fractions of a day, giving a resolution of 1/24855 of a second: > 2^31/(60*60*24) = 24855.134814814814814814814814815 > > Plenty enough for milli-second resolution. > > Probably not very good for embedded applications if an FPU is not > available.
Darn it... I needed 1/24856th second precision... -- Scott Baker - Canby Telcom RHCE - System Administrator - 503.266.8253 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------