On 7/1/2018 2:37 PM, danap wrote:
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.

select (julianday('now') - julianday('1970-01-01'))*24*60*60*1000
Igor Tandetnik

sqlite-users mailing list

Reply via email to