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