我试图使用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: ''