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. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
