如何取XX年XX月XX日XX时XX分

[gpkhh]

我数据库里有Date这个字段，类型为datetime,我如何在SQL SERVER里的SELECT语句中写取XX年XX月XX日XX时XX分，因为datetime的默认是年/月/日 00：00：00

我是新手，求大虾们教我

[-晴天]

datepart函数

[twgxzjk]

select cast(year(date) as varchar)+'年'+cast(month(date) as varchar)+'月'+cast(day(date) as varchar)+'日'+cast(datepart(hh,date) as varchar)+'时'+cast(datepart(mi,date) as varchar) +'分'

[twgxzjk]

select cast(year(date) as varchar)+'年'+cast(month(date) as varchar)+'月'+cast(day(date) as varchar)+'日'+cast(datepart(hh,date) as varchar)+'时'+cast(datepart(mi,date) as varchar) +'分'

from t