SQLAlchemy DateTime时区

from sqlalchemy import create_engine, Column, Integer, String, DateTime
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
from sqlalchemy.sql import select
import datetime
from sqlalchemy import func
from sqlalchemy.sql import text

# 创建一个基类
Base = declarative_base()

# 定义一个 User 类，映射到数据库中的 user 表
class User(Base):
    __tablename__ = 'user'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    created_at = Column(DateTime)

# 创建一个数据库引擎
engine = create_engine('sqlite:///test.db')

# 创建表
Base.metadata.create_all(engine)

# 创建一个会话
Session = sessionmaker(bind=engine)
session = Session()

# 添加一个新用户
new_user = User(name='John', created_at=datetime.datetime.now())
session.add(new_user)
session.commit()

# 查询用户
query = session.query(User).filter(User.name == 'John')
user = query.first()

# 打印用户的创建时间
print(user.created_at)

# 关闭会话
session.close()