sql按每天count 谢谢

数据不多 30000条左右 想看看每一天的个数
时间字段是2010-1-21 8:55:44格式的
我就是想看看每天的数量 语句怎么写 谢谢

---

select to_char(date,'yyyymmdd'),count(*) from XXX group by to_char(date,'yyyymmdd')

---

select count(*) from table_name
group by to_char(c_date, 'yyyy-mm-dd')

---

我今天回帖怎么总晚一点。。。。
郁闷

---

SQL code:
select to_char(to_date(col,'yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd'),count(1) from tb
group by to_char(to_date(col,'yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd');

---

谢谢

---

如果时间字段是date类型，用#1
如果是字符串类型用#4

---

SQL code:

select date,count(*) from XXX group by trunc(sysdate,'dd')

---

修改下:

SQL code:


select date,count(*) from XXX group by trunc(date,'dd')