请帮忙看看这个SQL语句哪里错了

[leon51]

我想查找时间相差2分钟以内的记录，但下面的语句出现了多条记录，请问如何修改？
SELECT ReceivedTime FROM Table
WHERE Sender='[e-mail]' AND DATEDIFF (minute,'2017/3/3 18:39:35', ReceivedTime )<=2


查询结果：

2017-02-21 18:46:36.000
2017-02-22 08:25:23.000
2017-02-22 09:15:34.000
2017-02-20 22:48:08.000
2017-02-21 09:11:11.000

[Andy-W]

SELECT ReceivedTime FROM Table WHERE Sender='[e-mail]' and ReceivedTime between '2017/3/3 18:39:35' and '2017/3/3 18:41:35'

[二月十六]

SELECT ReceivedTime  FROM Table
WHERE Sender='[e-mail]' AND DATEDIFF (minute,ReceivedTime,'2017/3/3 18:39:35' )<=2 

ReceivedTime写前边，要不是负的，所以小于2

[leon51]

Andy, 多谢你的回复，你的结果是OK的，但是我那个DATEDIFF函数错哪里了，我是放在程序代码中，如果用Between似乎不方便？

[leon51]

， ，