数据库学习_mysql server_pymysql_报错TypeError: Object of type ‘datetime‘ is not JSON serializable

问题出现

在使用json.dumps()字典时出现错误，发现是字典中包含SQL日期类型数据

问题解决

重写dumps的规则

import datetime
import json
 
class DateEncoder(json.JSONEncoder):
    def default(self, obj):
        if isinstance(obj,datetime.datetime):
            return obj.strftime("%Y-%m-%d %H:%M:%S")
        else:
            return json.JSONEncoder.default(self,obj)
 
dic={'name':'jack', 'create_time': datetime.datetime(2019, 3, 19, 10, 6, 6)}
 
print(json.dumps(dic,cls=DateEncoder))

https://blog.csdn.net/t8116189520/article/details/88657533