On 10/23/19, Peng Yu <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
