SQLite数据怎么查询DateTime字段(精确到毫秒级)某个时间段之后的数据

Question

SQL语句该怎么写？

Answer 1

select * from A where datetimeA >= datetime('2014-04-01 12:00:00.000') and datetimeA <= datetime('2014-04-02 12:00:00.000')本回答被提问者采纳