The time precision treated with and defined, ISO-8601, seems to be
with regard to seconds. Storage of an Integer for time as an example
in SQLite:

sqlite> SELECT STRFTIME('%s', 'now', 'localtime');

A 10 digit value. The issue I'm having is with regard to storage
of time, in milliseconds, a 13 digit value. I would assume a more
appropriate precision for a scientific community.

Looking briefly at the c library for strftime() it does not seem
to provide the possibility for a millisecond precision?

STRFTIME('%ms'), Integer
TIME(DDDDDDDDDDDDD), 13 digits, Text.

sqlite-users mailing list

Reply via email to