第一种：
b.Date as IncomeDateYear,
datename(year,b.Date) as IncomeDateYear,datename(month,b.Date) as IncomeDateYear,datename(day,b.Date) as IncomeDateYear,
第二种：
year(b.Date) as '年',month(b.Date) as '月',day(b.Date) as '日'
第三种：
DATEPART(yy, b.Date) as '年',DATEPART(MM, b.Date) as '月',DATEPART(DD, b.Date) as '日',
扫一扫
8351
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
