pymysql中将日期转换为字符串

SQL语句中使用DATE_FORMAT函数直接转换

sql = f'SELECT DATE_FORMAT(a.date,"%Y-%m-%d") as date1 FROM places_result AS a'

这样得出的数值就为字符串。

使用python的strftime函数转换

import datetime
sql = f'SELECT a.date FROM places_result AS a'
cursor.execute(sql)
results = cursor.fetchall()
for result in results:
    s = result[0].strftime('%Y-%m-%d')
    print(type(s))

strptime函数则与strftime相反，是将字符串转换为时间类型