27,579
社区成员
发帖
与我相关
我的任务
分享
Select CONVERT(varchar(100), cast('2014/9/1' as datetime), 112)
--Select CONVERT(varchar(100), cast('字段列名' as datetime), 112) from 表名
DECLARE @sxml XML
DECLARE @datearray VARCHAR(MAX)=
'2014/9/1
2014/9/2
2014/9/3
2014/9/4
2014/9/5
2014/9/6
2014/9/7
2014/9/8
2014/9/9
2014/9/10
2014/9/11
2014/9/12
2014/9/13
2014/9/14
2014/9/15
2014/9/16
2014/9/17
2014/9/18
2014/9/19
2014/9/20
2014/9/21
2014/9/22
2014/9/23
2014/9/24
2014/9/25
2014/9/26
2014/9/27
2014/9/28
2014/9/29
2014/9/30
2014/10/1
2014/10/2
2014/10/3
2014/10/4
2014/10/5
2014/10/6
2014/10/7
2014/10/8
2014/10/9
2014/10/10
2014/10/11
2014/10/12
2014/10/13
2014/10/14
2014/10/15
2014/10/16
2014/10/17
2014/10/18
2014/10/19
2014/10/20
2014/10/21
2014/10/22
2014/10/23
2014/10/24
2014/10/25
2014/10/26
2014/10/27
2014/10/28
2014/10/29
2014/10/30
2014/10/31'
SET @sxml='<r><n>'+REPLACE(@datearray,CHAR(13)+CHAR(10),'</n><n>')+'</n></r>'
SELECT STUFF((SELECT ','+CONVERT(varchar(100),b.value('.','datetime'),112) FROM @sxml.nodes('r/n') AS s(b)
FOR XML PATH('')),1,1,'')