1.方法一:
截取的方法: varchar(7) 这个是按月
select Convert (varchar(7),CreateTime ,120) as Date
from dbo.AdminUser
group by Convert( varchar(7),CreateTime,120 )
方法二:
select
CONVERT(varchar(10),CreateTime,120) as Date
from dbo.AdminUser
group by CONVERT(varchar(10),CreateTime,120)
select case when Enabled=1 then '启用'
when Enabled=0 then '禁言'
else '空'
end from dbo.AdminUser
方法三:
select datepart (YY,CreateTime) from dbo.AdminUser group by datepart (YY,CreateTime)
select DATEPART (MM,CreateTime) from dbo.AdminUser group by DATEPART(MM,CreateTime)
select DATEPART (QQ,CreateTime) from dbo.AdminUser group by DATEPART (QQ,CreateTime)
select DATEPART(DD,CreateTime) from dbo.AdminUser group by DATEPART(DD,CreateTime)