取出DataTime的年,月,日,时,分 select LEFT(Convert(varchar(100),A.CreateTime,20), 16)FROM [TB_Business_Award] A