SELECT ...,...
FROM 表名
WHERE ( 字段时间2 BETWEEN ADD_SECONDS(TO_TIMESTAMP (字段时间1),-15*60)
AND ADD_SECONDS(TO_TIMESTAMP (字段时间1), 60*15) )
SELECT ...,...
FROM 表名
WHERE ( 字段时间2 BETWEEN ADD_SECONDS(TO_TIMESTAMP (字段时间1),-15*60)
AND ADD_SECONDS(TO_TIMESTAMP (字段时间1), 60*15) )