sqlite-按日期分组，根据日期查询详细内容

"select strftime(‘%Y-%m-%d‘,"+DBConfig.RUNNING_LOG_DATE+") as "+FORMAT_DATE+" from " +DBConfig.TABLE_RUNNING_LOG+" group by strftime(‘%Y-%m-%d‘,"+DBConfig.RUNNING_LOG_DATE+") order by "+FORMAT_DATE+" desc";

二.根据日期查询详细内容

String paramString = "select * from "+DBConfig.TABLE_RUNNING_LOG+" where strftime(‘%Y-%m-%d‘,"+DBConfig.RUNNING_LOG_DATE+") = ‘"+dateStr+"‘ order by id desc";

 

sqlite-按日期分组，根据日期查询详细内容

标签：bsp   rom   running   blog   run   format   sqli   strftime   order   

本文系统来源：http://www.cnblogs.com/yongdaimi/p/7724312.html

【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！