- 论坛徽章:
- 0
|
我用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, '')
请教一下,如何修改脚本才能实现我的预期输出 |
|