Re: [sqlite] Why not allow subsecond file modification time in sqlar format?

2019-10-23 Thread Richard Hipp
On 10/23/19, Darren Duncan wrote: > On 2019-10-23 10:36 a.m., Richard Hipp wrote: >> On 10/23/19, Peng Yu wrote: >>> >>> 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?

Re: [sqlite] Why not allow subsecond file modification time in sqlar format?

2019-10-23 Thread Darren Duncan
On 2019-10-23 10:36 a.m., Richard Hipp wrote: On 10/23/19, Peng Yu 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

Re: [sqlite] Why not allow subsecond file modification time in sqlar format?

2019-10-23 Thread Peng Yu
But what about `sqlite3 -Atv`? I think it only supports INT time? On 10/23/19, Richard Hipp wrote: > On 10/23/19, Peng Yu 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

Re: [sqlite] Why not allow subsecond file modification time in sqlar format?

2019-10-23 Thread Richard Hipp
On 10/23/19, Peng Yu 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

[sqlite] Why not allow subsecond file modification time in sqlar format?

2019-10-23 Thread Peng Yu
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 -- Regards, Peng