下面的语句可以使时间字段很好的排序.
select *,(julianday(‘now’)*86400 -julianday([日期时间字段])*86400) as limits from [tablename] order by limits asc