jsnjzlw 发表于 2015-7-4 06:22:17

SQL SERVER按照日期格式的字段来GROUP BY

SQL SERVER数据表TABLE1,字段列表

StartTime    DateTime
EndTime    DateTime

字段StartTime的值如下:
2005-01-01 12:00:00
2004-12-23 11:00:11
2004-12-22 11:22:00
2005-01-01 14:00:00
2004-12-22 12:00:09




select convert(varchar(10), starttime,20) as 'DailyDate'    from table1 group by convert(varchar(10), starttime,20)

group by之后已自动排序

运行结果如下:
2004-12-22
2004-12-23
2005-01-01
页: [1]
查看完整版本: SQL SERVER按照日期格式的字段来GROUP BY