sqlite 时间排序

select * from tb_QuantifyResult where iSamplingOrCalibration = 1 and cComponentName <> ' + QuotedStr('') + ' order by date(cPeakTime) desc,  time(cPeakTime) desc 

原文地址:https://www.cnblogs.com/zhangzhifeng/p/5829003.html