Alexey Pechnikov wrote: > Please speak is now correct to store 'start of month' dates in > julianday format?
Was it at some point "incorrect" to do so? Yes, you can store any date in julian day format, start of month or otherwise. > Does SQLite now uses internal reprezentation of > microseconds for the julianday and store it as long integer or float? Julian day format is a double, with date represented by the whole part and time by the fractional part. A double has 53 bits of mantissa, IIRC, of which some 22 bits are needed to represent dates in recent past and future, leaving 31 bits for time. This gives a resolution of about 40 microseconds - so no, the format is incapable of representing times accurate down to a microsecond. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
