PyMySQL模塊查詢(xún)帶有時(shí)間格式字段的記錄時(shí)輸出異常

Feyiz

我用python3.4調(diào)用pymysql模塊連接MySQL數(shù)據(jù)庫(kù)，查詢(xún)帶有時(shí)間格式的字段時(shí)，輸出異常。
代碼如下：

1. # -*- coding: utf-8 -*-
   
2. import pymysql
   
3. 
   
4. 
   
5. def dump(tablename):
   
6.     cur.execute("select * from " + tablename)
   
7.     for each in cur:
   
8.         print(each)
   
9. 
   
10. conn = pymysql.connect(host='127.0.0.1', user='roach', passwd='roach', db='roach', charset='utf8')
    
11. cur = conn.cursor()
    
12. dump('squad')
    
13. cur.close()
    
14. conn.close()

復(fù)制代碼

實(shí)際輸出如下：
(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, '')
我需要的預(yù)期輸出格式如下：
(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, '')
請(qǐng)教一下，如何修改腳本才能實(shí)現(xiàn)我的預(yù)期輸出

Linux_manne

format(date) 即可