sqlite删除之前的数据

delete from  GpsData WHERE  CreateTime BETWEEN  '2017-01-01 00:00:00'  AND  datetime('now','localtime','-1 day');



测试：

SELECT  datetime('now','localtime','-1 hours');

SELECT  date('now','-1 day');
 
SELECT  datetime('now','localtime');