我试图使用python 2.7和dbf模块在* .dbf文件中的表上进行日期时间查询,但是已经失败了 .

这是我的代码:

import dbf
from datetime import datetime  
file = dbf.Table('databaseName.DBF')
db = file.open()
print db[0]['data']
print type(db[0]['data'])

output:
2018-11-05 <type 'datetime.date'>

查询:

dateToSearch = datetime.strptime('11/5/2018','%m/%d/%Y').date()
print dateToSearch
print type(dateToSearch)
try:
    db.query('select * where data == {0}'.format(dateToSearch))
except Exception as e:
    print e
    pass
try:
    index = db.create_index(lambda rec: rec.data)
except Exception as e:
    print e
    pass

Output

2018-11-05
<type 'datetime.date'>
invalid literal for int() with base 10: ''
invalid literal for int() with base 10: ''