查询固定步长的时间SQL

select STime  from V_DH01
where (datediff( s,'2009-12-4 11:00:00',STime)%210)=0 and STime<='2009-12-4 14:00:00' and STime>='2009-12-4 11:00:00'

从起始时间2009-12-4 11:00:00查询间隔210秒到结束时间2009-12-4 14:00:00的所有时间
即：从起始时间2009-12-4 11:00:00以210秒为步长的到到结束时间2009-12-4 14:00:00的所有时间

转载于:https://blog.51cto.com/rosehacker/491282