这个是小时的 年月日的yy / qq / mm自己加吧
得到一个字串
select cast(DATEPART(hh,日期) as varchar(10)),cast(DATEPART(mi,日期) as varchar(10)),cast(DATEPART(ss,日期) as varchar(10)) from shinz_ghzl
set dateformat dmy
select convert(varchar,cast('31/08/2004 15:08' as datetime),112)
+replace(convert(varchar(5),cast('31/08/2004 15:08' as datetime),108),':','')
set dateformat ymd