python sqlsever 时间查询,python中的SQL查询日期范围

我只是想查询一个特定日期范围内的SQLServer数据库。不知怎么的，我自己就是搞不懂。以下是我所做的：import pyodbc

import pandas as pd

con = pyodbc.connect("Driver={SQL Server}; Server=link")

tab = pd.read_sql_query("SELECT * FROM OPENQUERY(aaa, 'SELECT * FROM bbb.ccc WHERE number like (''K12345%'')')",con)

tab['DT']

0 2015-09-17 08:51:41

1 2015-09-17 09:14:09

2 2015-09-17 09:15:03

3 2015-09-24 15:20:55

4 2015-09-24 15:23:47

5 2015-10-02 08:49:59

6 2015-10-30 14:08:40

7 2015-10-30 14:13:38

8 2015-11-03 14:30:06

9 2015-11-03 14:30:22

10 2015-11-04 07:14:40

11 2015-11-04 10:43:51

Name: DT, dtype: datetime64[ns]

现在我想我应该能够使用下面的查询选择2015-09-18和{}之间日期的记录。不知怎么的，它失败了DatabaseError: Execution failed on sql: SELECT * FROM OPENQUERY(aaa, 'SELECT * FROM bbb.ccc WHERE DT between ''2015-09-18'' and ''2015-10-02''')".

有人能帮我解释一下我做错了什么吗？在

^{pr2}$