On 2019-10-23 10:36 a.m., Richard Hipp wrote:
On 10/23/19, Peng Yu <pengyu...@gmail.com> wrote:
Hi,
https://www.sqlite.org/sqlar.html
Only integer is allowed for last modification time. Why not allow
subsecond file modification time in sqlar format, given subsecond time
is allowed in many OSes? Thanks.
mtime INT, -- last modification time
The datatypes for table columns in SQLite are suggestions, not
requirements. The implementation could be enhanced to store the mtime
as a floating-point value, and everything would continue to work the
same.
Why float? Shouldn't a standard 64-bit integer be able to represent all the
subsecond time precision people would want? -- Darren Duncan
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
