mysql的查询语句,可以把结果以2007-03类似的格式查询出来。。
select DATE_FORMAT(MonDate,'%Y-%m') as anaMonth from mon_log where GroupNo=? group by anaMonth order by anaMonth desc;我想问同样的要求,在sql server2000里面怎么写??
select DATE_FORMAT(MonDate,'%Y-%m') as anaMonth from mon_log where GroupNo=? group by anaMonth order by anaMonth desc;我想问同样的要求,在sql server2000里面怎么写??
....where GroupNo='1' group by ....
from tb
group by convert(varchar(7),时间字段,120)
Select Convert(Varchar(7), GetDate(), 121)
--Result
/*
2007-03
*/