表A: id starTime endTime 都是int字段 1 20091231 20100102 2 20100113 20100115 3 20100110 20100117 需求：查询出离今天最近的数据，如：今天2010-01-11 转成20100111 再分别与starttime 和endtime比较，那个最接近今天查询哪个。 查出 第3条。SQL code: if object_id('[tb]') is not null drop table [tb] go create table [tb] (id int,starTime int,endTime int) insert into [tb] select 1,20091231,20100102 union all select 2,20100113,20100115 union all select 3,20100110,20100117
select * from [tb] where cast(convert(varchar(10),getdate(),112)as int) between starTime and endTime /* id starTime endTime ----------- ----------- ----------- 3 20100110 20100117
