Sqlite 删除早于此日期的行

Question

我在数据库中有记录：

record B with property `Checked` set to be current date in UTC.
record A with property `Checked` set to be current date in UTC - 48 hours.

然后我想创建查询以删除属性Checked超过 24 小时的行。

就我而言，只应删除A。Checked以bigint的形式存储在数据库中。

db.Execute("DELETE FROM User WHERE Checked <= strftime('%s', datetime('now', '-1 day'))"); // A and B are not deleted
db.Execute("DELETE FROM User WHERE Checked <= datetime('now', '-1 day')"); // A and B are deleted
db.Execute("DELETE FROM User WHERE Date(checked) <= datetime('now', '-1 day')"); // A and B are not deleted
db.Execute("DELETE FROM User WHERE datetime(checked) <= datetime('now', '-1 day')"); // A and B are not deleted

你有什么想法吗？

Answer 1

我终于找到了一个解决方案：

datetime(Checked/10000000 - 62135596800, 'unixepoch') <= datetime('now', '-1 day')