13位时间戳转换为时间格式
import time
timeArray = 1542297599000
timeArray = time.localtime(int(str(timeArray)[:10:]))
otherStyleTime = time.strftime("%Y-%m-%d %H:%M:%S", timeArray)
print(otherStyleTime)
运行结果:
excel表格读取时间戳并转换为时间格式
from xlrd import xldate_as_tuple
from datetime import datetime
F_Release_time = datetime(*xldate_as_tuple(sheet.cell(r, 4).value, 0)).strftime('%Y-%m-%d')