oracle 与ms sql对日期字段使用group by
oracle:
select to_char(date_time,'yyyymmdd'),count(*) from table_name where ……
group by to_char(date_time,'yyyymmdd')
order by to_char(date_time,'yyyymmdd')
或
select trunc(date_time),count(*)
from table_name
where .......
group by trunc(date_time)
ms sql:
SELECT SUM(field_name) FROM table_name GROUP BY month(date_time)
--上面这句只和月份有关,与年份无关
或
SELECT SUM(field_name) FROM table_name GROUP BY CONVERT(char(10),date_time,121)