python - 从 sqlalchemy 查询结果中获取对象类日期时间

Question

我尝试从 sqlalchemy 查询中获取 datetime 对象类，如下所示：

curr_date = engine.execute("SELECT getdate() ").fetchall()
dt = [d.strptime('%d/%m/%y %H:%M:%S') for d in curr_date]

并得到这个错误：

Traceback (most recent call last):
...
dt = [d.strptime('%d/%m/%y %H:%M:%S') for d in curr_date]
AttributeError: Could not locate column in row for column 'strptime'

求大神指教，怎么解决？

标签： pythonsqlalchemy

Answer 1

好像我解决了：

curr_date = engine.execute("SELECT getdate() ").fetchone()
print(curr_date[0])