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

weixin_33725272

于 2017-10-24 16:33:00 发布

阅读量1.4k

点赞数

文章标签：数据库 c# 移动开发

一.按日期分组

String paramString = "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";