存储时间的字段是字符串格式? SQL code: group by datediff(mi,convert(varchar(10),getdate(),120),'2010-02-19')/30
存储时间的字段是 Datetime 型
SQL code: IF OBJECT_ID('TB') IS NOT NULL DROP TABLE TB GO CREATE TABLE TB(COL1 VARCHAR(50)) INSERT INTO TB SELECT '12:38:00' UNION ALL SELECT '03:11:00' UNION ALL SELECT '08:12:00' UNION ALL SELECT '01:58:00' UNION ALL SELECT '05:29:00' UNION ALL SELECT '09:13:00' UNION ALL SELECT '14:34: