how to change datetime to string in sqlalchemy query? [duplicate]

Question

this is my code, query Notification.create_time

result = session.query(
        Notification.content, cls.is_read,
        Notification.create_time).join(
        cls, Notification.id == cls.notification).filter(
            and_(cls.user == user_id)).order_by(
                Notification.create_time.desc()).all()

in other place need to json.dumps query result to frontend, datetime format cann't json.dumps, so I want to do like this:

session.query(Notification.create_time.strftime('%Y-%m-%d %H:%M'))

so, how to change datetime to string in sqlalchemy query?

Answer 1

Can use func.to_char() (in postgres, not sure about mysql) to convert a datetime to a string, something like:

from sqlalchemy.sql import func
session.query(func.to_char(Notification.create_time, '%Y-%m-%d %H:%M'))

But the better way it to set up your json serializer to handle things like datetimes, as is described in this answer