--将日期转换成字符串并截取月份和日期4位,然后在字符串末尾加上3位随机字符串
Select SUBSTRING(CONVERT(nvarchar(50), CAST ( '2016-04-25 08:41:07.720' AS Date ), 12),3,4) +
SUBSTRING(Convert(nvarchar(50),NewID()),1,3)
--将日期转换成字符串
Select CONVERT(nvarchar(50), CAST ( '2016-04-25 08:41:07.720' AS Date ), 12)