1、sqlite通过时间字段排序(备注:mctime为表时间字段) select *,(julianday(mctime)*86400-julianday('now')*86400) as limits from messageinfo order by limits desc 2、查询当前时间:select datetime('now') 3、在原有时间上加、减.备注(这里是在当前时间上减去time秒,如果是分钟、小时、日、月,只要把second关键词换掉即可) select datetime('now','-"+time+" second') select datetime('now','+"+time+" second')