AWS Lmbda TypeError:datetime.datetime（2012,8,8,21,46,24,862000）不可JSON序列化[重复]

Question

我正试图从m RDS数据库中返回一套装备。dte字段均采用DATETIME格式，这导致我出现以下错误：

TypeError: datetime.datetime(2012, 8, 8, 21, 46, 24, 862000) is not JSON serializable

我怎么才能绕过这个？

这是我的代码：

import pymysql
import json
from rds import *

#rds settings
host  = rds_host
name = rds_name
password = rds_password
db_name = rds_db_name
port = rds_port

try:
    conn = pymysql.connect(host = host, user=name, passwd=password, db=db_name, connect_timeout=5)

except:
    raise Exception('Database Error: The server encountered an unexpected condition which prevented it from fulfilling the request.')


def handler(event, context):

    cur = conn.cursor(pymysql.cursors.DictCursor)
    #selects a user from the database
    query = "SELECT * FROM Outfits WHERE outfit_id = '" + event['outfitId'] + "' LIMIT 1"
    #runs the SQL query
    try:
        cur.execute(query)
    except:
        raise Exception('Internal Error: The server encountered an unexpected condition which prevented it from fulfilling the request.')

    #stores the downloaded record into the user variable
    rows = cur.fetchone()
    return result

Answer 1

您不能以其他格式存储日期时间吗？看起来查询数据库的响应是JSON格式的，将日期存储为字符串肯定会更有效率？

Answer 2

datetime.datetime对象不能被JSON序列化，您需要在JOSN序列化之前将它们转换为字符串。您可以使用. strftime（）将您的datetime.datetime对象转换为字符串。