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--结果: 200408311508
这个是小时的 年月日的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
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--结果: 200408311508
set @a='31/08/2004 15:08'select
substring (@a,7,4)+
substring(@A,4,2)+
substring (@a,1,2)+
substring (@a,12,2)+
substring (@a,15,2)
得到一个字串
select cast(DATEPART(hh,日期) as varchar(10)),cast(DATEPART(mi,日期) as varchar(10)),cast(DATEPART(ss,日期) as varchar(10)) from shinz_ghzl