Pymongo将时间戳转换为日期作为新字段

from pymongo import MongoClient
from datetime import datetime

# 连接到 MongoDB 数据库
client = MongoClient('mongodb://localhost:27017/')
db = client['mydatabase']
collection = db['logs']

# 查询所有文档并将时间戳转换为日期字符串
for doc in collection.find():
    timestamp = doc['timestamp']
    date_str = datetime.fromtimestamp(timestamp).strftime('%Y-%m-%d %H:%M:%S')
    doc['date'] = date_str
    collection.update_one({'_id': doc['_id']}, {'$set': {'date': date_str}})

# 打印转换后的文档
for doc in collection.find():
    print(doc)

# 假设时间戳是以毫秒为单位的
timestamp_ms = doc['timestamp']
timestamp_s = timestamp_ms / 1000.0
date_str = datetime.fromtimestamp(timestamp_s).strftime('%Y-%m-%d %H:%M:%S')

from datetime import timezone

# 使用 UTC 时区
date_str = datetime.fromtimestamp(timestamp_s, tz=timezone.utc).strftime('%Y-%m-%d %H:%M:%S')