Question

SQLite数据库查询结果按时间排序怎么实现

Answer 1

数据库好像都是这样的吧

select * from t order by "时间字段" 默认升序，降序只需要语句后加 desc

Answer 2

你写成：select * from ReturnGoodsMains where datetime(ReturnDate)>='2012-12-02 00:00:00' and datetime(ReturnDate)<'2012-12-03 00:00:00' ;
试试。