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