PyMySQL模块查询带有时间格式字段的记录时输出异常
我用python3.4调用pymysql模块连接MySQL数据库,查询带有时间格式的字段时,输出异常。代码如下:# -*- coding: utf-8 -*-
import pymysql
def dump(tablename):
cur.execute("select * from " + tablename)
for each in cur:
print(each)
conn = pymysql.connect(host='127.0.0.1', user='roach', passwd='roach', db='roach', charset='utf8')
cur = conn.cursor()
dump('squad')
cur.close()
conn.close()实际输出如下:
(1, '第一', '08:00:00', '15:59:59', datetime.datetime(2015, 12, 18, 11, 41, 47), 0, '')
(2, '第二', '16:00:00', '23:59:59', datetime.datetime(2015, 10, 25, 16, 31, 24), 0, '')
(3, '第三', '00:00:00', '07:59:59', datetime.datetime(2015, 10, 25, 16, 30, 36), -1, '')
我需要的预期输出格式如下:
(1, '第一', '08:00:00', '15:59:59', '2015-12-18 11:41:47', 0, '')
(2, '第二', '16:00:00', '23:59:59', '2015-10-25 16:31:24', 0, '')
(3, '第三', '00:00:00', '07:59:59', '2015-10-25 16:30:36', -1, '')
请教一下,如何修改脚本才能实现我的预期输出 format(date) 即可
页:
[1]