SET `time_str` = STR_TO_DATE(`time_str`,'%d/%m/%Y %H:%i')
from datetime import datetime import pytz datetime.fromtimestamp(1563396127, tz=pytz.utc)