开发者

Deleting all but last 5 min of data

开发者 https://www.devze.com 2023-03-24 18:32 出处:网络
I am trying to delete entries over 5 min old. Looking at SQLite\'s datetime function I attempted : DELETE FROM MyTable WHERE TimeStamp < datetime(\'now\', \'-5 minutes\')

I am trying to delete entries over 5 min old. Looking at SQLite's datetime function I attempted :

DELETE FROM MyTable WHERE TimeStamp < datetime('now', '-5 minutes')

This erases all data however, not just last 5 mins. When using a datetime object (toString()) it does nothing. Does anyone hav开发者_开发问答e a solution?

0

精彩评论

暂无评论...
验证码 换一张
取 消