Convert int back to datetime?

Question

The database table with a datetime column is read and returned by a restful api.

from sqlalchemy import Column, DATETIME
class Table(base)
    datetime = Column(DATETIME)

However, the API return integers for the column datetime.

1622332800000
1622937600000
1623542400000
1624147200000

How to convert these values back to datetime?

user_16936785 · Answer

You may try the following:

import datetime
timestamp = datetime.datetime.fromtimestamp(1002332800)
timestamp.strftime('%Y-%m-%d %H:%M:%S')

The output should be:

>>>> 2001-10-06 04:46:40