But what about `sqlite3 -Atv`? I think it only supports INT time? On 10/23/19, Richard Hipp <d...@sqlite.org> 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. > -- > 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 >
-- Regards, Peng _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users