--格式统一的情况下 SELECT MAX(time_field) FROM table_name --不统一时,只有时间部分,可转换为DATETIME类型再比较 SELECT MAX(CAST(time_field AS DATETIME)) FROM table_name
--> 数据库版本: --> Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 --> 测试数据:[TB] IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[TB]') AND type in (N'U')) DROP TABLE [TB] GO---->建表 create table [TB]([时间] char(20)) insert [TB] select '16:20:59' union all select '16:21:59' union all select '23:20:59' union all select '23:59:59' GO--> 查询结果 SELECT MAX([时间]) FROM [TB] --> 删除表格 --DROP TABLE [TB]
SELECT MAX(time_field) FROM table_name
--不统一时,只有时间部分,可转换为DATETIME类型再比较
SELECT MAX(CAST(time_field AS DATETIME)) FROM table_name
--> 数据库版本:
--> Microsoft SQL Server 2008 (RTM) - 10.0.1600.22
--> 测试数据:[TB]
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[TB]')
AND type in (N'U'))
DROP TABLE [TB]
GO---->建表
create table [TB]([时间] char(20))
insert [TB]
select '16:20:59' union all
select '16:21:59' union all
select '23:20:59' union all
select '23:59:59'
GO--> 查询结果
SELECT MAX([时间]) FROM [TB]
--> 删除表格
--DROP TABLE [TB]