,按小时分组
-- 按小时产生连续的
SELECT
substring(convert(char(32),DATEADD(HH,number,CONCAT('2019-01-18',' ', '00...DATEDIFF(HH,DATEADD(HH,number,CONCAT('2019-01-18',' ', '00:00')),CONCAT('2019-01-18',' ', '23:00'))>=0
-- 按小时统计交易笔数...,按小时分组
select isnull(convert(varchar(2), sv.number) + '-' + convert(varchar(2), sv.number + 1), '合计')...CONVERT(VARCHAR(10),GETDATE(),120) –2015-07-13
SELECT CONVERT(VARCHAR(10),GETDATE(),101) –07/13/2015
–按日分组...month,CreateDate) as Times,sum(Unit) as Totals from pdt_Out
group by DATEPART(month,CreateDate)
go
–按年分组