select left(convert(varchar,getdate(),21),7)
select convert(varchar(7),getdate(),120)
year(time)+'-'+month(time)
select left(convert(varchar,getdate(),21),7)
select convert(varchar(7),getdate(),120)
year(time)+'-'+month(time)
转载于:https://www.cnblogs.com/monkeyfather/p/3892795.html