上面说的在sql语句中,不能用。下面的sql语句只有月 怎样才能把下面的sql语句,改成年月的呢?》? select month(login_time) as 月份 ,count(login_time) as 会员登陆次数 from tablogin group by month(login_time)
select convert(nvarchar(4),Year(login_time))+'-'+convert(nvarchar(2),month(login_time)) as 月份 ,count(login_time) as 会员登陆次数 from tablogin group by convert(nvarchar(4),Year(login_time))+'-'+convert(nvarchar(2),month(login_time))
Year(date1)+'-'+month(date1)
delphi
yearof(date1)+'-'+monthof(date1)
convert(nvarchar(4),Year(date1))+'-'+convert(nvarchar(2),month(date1));
delphi
inttostr(yearof(date1))+'-'+inttostr(monthof(date1));
怎样才能把下面的sql语句,改成年月的呢?》?
select month(login_time) as 月份 ,count(login_time) as 会员登陆次数 from tablogin group by month(login_time)
select convert(nvarchar(4),Year(login_time))+'-'+convert(nvarchar(2),month(login_time)) as 月份 ,count(login_time) as 会员登陆次数 from tablogin group by convert(nvarchar(4),Year(login_time))+'-'+convert(nvarchar(2),month(login_time))