select CONVERT(VARCHAR(10),SampleTime,120) AS SampleTime from [dbo].[QUA_JBlampblack] 转换后的格式为 2016-07-01