sqlalchemy日期

2019独角兽企业重金招聘Python工程师标准>>>

SqlAlchemy中的DateTime

from sqlalchemy import Column, String, DateTime
from app import Base
class User(Base):
    __tablename__ = 'user'
    id = Column(String(64), primary_key=True)
    create_time = Column(DateTime)

Python中的

import uuid
import datetime
from app.models import User
from app import db_session

@user_blueprint.route('/new')
def new():
    user = User()
    user.id = uuid.uuid4()
    user.create_time = datetime.datetime.now()
    db_session.add(user)
    db_session.commit()
    return success_resp()

时间转换为字符串

user.create_time.strftime("%Y-%m-%d %H:%M:%S")

 

转载于:https://my.oschina.net/u/1185936/blog/1576095