Tom Olson <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I know that SQLite uses a 64-bit floating point type to store Julian date
> information. Is this accurate to the second or a fraction of a second?
>
> I was doing some testing and tried to format a date using strftime() method
> with the %f option and I was unable to find a date that kept any millisecond
> information and after reviewing the date.c file it does not appear to
> capture anything more accurate than a second. Is this correct?
>
A double is sufficient to store the current time to with about
25 microseconds. If you use 'now' to get the current time, the
date functions try to capture the current time to this precision.
That is implemented in the os_XXX.c layer. It's system dependent.
Check to see what your system is doing.
If you enter the date in ISO8601, it captures up to milliseconds.
Ex:
SELECT strftime('%Y-%m-%d %H:%M:%f', '2001-09-11 09:32:42.437');
This works for me. I see the full ".437" at the end. Are you
saying that you do not?
--
D. Richard Hipp <[EMAIL PROTECTED]>
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
