SQLite Qurey获取每周数据
问题描述:
嗨
如何使用sqlite查询获取每周数据.
如果从该日期中选择一个日期,则需要每周一次获取数据.
问候,
karthick
Hi
How to get weekly data using sqlite query .
if select one date from that date i need to get data accordly weekly .
Regards,
karthick
答
您提供的信息不多,下面是一个示例查询:
You haven''t supplied much to go on, but here''s an example query:
SELECT COUNT(*),STRFTIME('%Y-%W',created,'unixepoch') AS creat
FROM Files GROUP BY creat
该查询计算文件"表中的条目数,按周分组.
SQLite日期函数: http://www.sqlite.org/lang_datefunc.html [
This query counts the number of entries in the Files table, grouped by week.
SQLite date functions: http://www.sqlite.org/lang_datefunc.html[^]