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? If I need millisecond information I assume that I should be using the ISO 8601 format and store the dates as text. Is this correct? Tom -- View this message in context: http://www.nabble.com/Precision-of-dates-stores-as-Julian-%22real%22-tf3264210.html#a9073506 Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
