select * from TB where datediff(mi,[时间字段], dateadd(mi,30,[时间字段]))>0 And datediff(mi,[时间字段], dateadd(mi,30,[时间字段]))<30
SELECT * FROM TB WHERE condition BETWEN CAST('2010-10-11 13:27:30' AS DATETIME) ADN DATEADD(MI,30,CAST('2010-10-11 13:27:30' AS DATETIME))
SELECT * FROM TB WHERE condition BETWEN CAST('2010-10-11 13:27:30' AS DATETIME) ADN DATEADD(MI,30,CAST('2010-10-11 13:27:30' AS DATETIME)) 正解,可以多查查sql的帮助文档
datediff(mi,[时间字段], dateadd(mi,30,[时间字段]))<30
ADN DATEADD(MI,30,CAST('2010-10-11 13:27:30' AS DATETIME))
ADN DATEADD(MI,30,CAST('2010-10-11 13:27:30' AS DATETIME))
正解,可以多查查sql的帮助文档
declare @name datetime
set @name='2010-10-11 13:27:30'
select dateadd(mi,30,@name) as'时间'
ADN DATEADD(MI,30,CAST('2010-10-11 13:27:30' AS DATETIME))
ADN DATEADD(MI,30,CAST('2010-10-11 13:27:30' AS DATETIME))
select * from 表 where 时间列 > '已知时间' and 时间列 < DATEADD(MINUTE,30,'已知时间')