如果是指分钟.select right(convert(varchar(16),时间字段,120),1) in {'5','9'}
create table tb(dt datetime) insert into tb values('2010-06-20 14:35:00') insert into tb values('2010-01-20 14:32:00') goselect * from tb where right(convert(varchar(16),dt,120),1) in ('5','9')drop table tb/* dt ------------------------------------------------------ 2010-06-20 14:35:00.000(所影响的行数为 1 行)*/
CREATE TABLE #tp ( id INT IDENTITY, [time] datetime )INSERT INTO #tp SELECT '2010-06-20 14:35:00' UNION ALL SELECT '2010-01-20 14:32:00'SELECT * FROM #tp t WHERE SUBSTRING(CONVERT( VARCHAR (30),[time],120),16,1) IN('5','9')id time ----------- ----------------------- 1 2010-06-20 14:35:00.000(1 row(s) affected)
insert into tb values('2010-06-20 14:35:00')
insert into tb values('2010-01-20 14:32:00')
goselect * from tb where right(convert(varchar(16),dt,120),1) in ('5','9')drop table tb/*
dt
------------------------------------------------------
2010-06-20 14:35:00.000(所影响的行数为 1 行)*/
(
id INT IDENTITY,
[time] datetime
)INSERT INTO #tp
SELECT '2010-06-20 14:35:00' UNION ALL
SELECT '2010-01-20 14:32:00'SELECT * FROM #tp t
WHERE SUBSTRING(CONVERT( VARCHAR (30),[time],120),16,1) IN('5','9')id time
----------- -----------------------
1 2010-06-20 14:35:00.000(1 row(s) affected)