安道生網站技術練功房 - 分享經驗，累積智慧

cast(datepart(yyyy, birthday) as varchar)+'年'+right('00'+cast(datepart(mm, birthday) as varchar), 2)+'月'+right('00'+cast(datepart(dd, birthday) as varchar), 2)+'日' as birthday_string

datepart(yyyy, birthday) AS birth_year, right('00'+cast(datepart(mm, birthday) as varchar), 2) AS birth_month, 
right('00'+cast(datepart(dd, birthday) as varchar), 2) AS birth_day