34,590
社区成员
发帖
与我相关
我的任务
分享
create table t(id int,d date);
insert into t(id,d)
select 1,to_date('2017-08-08','YYYY-MM-DD') union all
select 2,'2017-08-07' union all
select 3,'2017-08-07' union all
select 4,'2017-08-06' union all
select 5,'2017-08-06' union all
select 6,'2017-08-06' union all
select 7,'2017-08-05'
select count(0),to_char(d,'YYYY-MM-DD') from t where d between '2017-08-06' and '2017-08-10'
group by to_char(d,'YYYY-MM-DD')
2;"2017-08-07"
1;"2017-08-08"
3;"2017-08-06"
SELECT COUNT(*) ,
to_date(paytime, 'DD Mon YYYY')
FROM java_langzi.t_shop_order
WHERE paytime BETWEEN '2017-08-09' AND '2017-08-19'
GROUP BY to_date(paytime, 'DD Mon YYYY')
postgresql数据库
SELECT COUNT(*) ,
DATENAME(DAY, paytime)
FROM java_langzi.t_shop_order
WHERE paytime BETWEEN '2017-08-09' AND '2017-08-19'
GROUP BY DATENAME(DAY, paytime)