strftime函数
格式 说明
%d day of month: 00
%f fractional seconds: SS.SSS
%H hour: 00-24
%j day of year: 001-366
%J Julian day number
%m month: 01-12
%M minute: 00-59
%s seconds since 1970-01-01
%S seconds: 00-59
%w day of week 0-6 with Sunday==0
%W week of year: 00-53
%Y year: 0000-9999
%% %
数据表结构
Name Time Website
|
1 |
SELECT website as 板块 ,strftime('%m',Time) as 月份,count(Name) as 发帖数 from aa where strftime('%Y',Time)='2015' and website='发现之门' group by strftime('%m',Time) |
发表评论
要发表评论，您必须先登录。