sql server取时间单独取年、月、日

第一种：

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 '日',