原文:https://blog.csdn.net/qq_28135179/article/details/80097788
select cast(year(时间字段) as varchar(10))+'年'+cast(month(时间字段) as varchar(10))+'月'+cast(day(时间字段) as varchar(10))+'日' from 表名
原文:https://blog.csdn.net/qq_28135179/article/details/80097788
select cast(year(时间字段) as varchar(10))+'年'+cast(month(时间字段) as varchar(10))+'月'+cast(day(时间字段) as varchar(10))+'日' from 表名