有用的知识点整理
时间的相互转化
from dateutil.relativedelta import relativedelta
from datetime import *
import time
t = int(str(date.today()).split("-")[1])-3 #现在的日期与3月相差几个月
today = date.today() # 打印年月日
today_time = int(str((time.mktime(today.timetuple()))).split(".")[0]) #今天凌晨的时间戳
time_local = time.localtime(today_time)
#转换成新的时间格式(2016-05-05 20:28:54)
dt = time.strftime("%Y-%m-%d %H:%M:%S",time_local) #时间戳转化为时间格式，字符串
o_time = datetime.strptime(dt,"%Y-%m-%d %H:%M:%S")-relativedelta(months=t)
#字符串时间转化为时间格式 并回到三月份
now = datetime.now()-relativedelta(months=t)
print("today",today,)
print("today_time",today_time)
print(t)
print('o_time',o_time,type(o_time))
print(now,type(now))
SRE实战 互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。
today 2019-05-09 today_time 1557331200 2 o_time 2019-03-09 00:00:00 <class 'datetime.datetime'> 2019-03-09 09:40:39.927366 <class 'datetime.datetime'>
Django ORM中打印sql语句
fws = FaultWarning.objects.filter(type='ERROR',create_time__gt=st_time,create_time__lt=now) print(fws.query)
data = FaultWarningSerializer(fw, many=True, context={"request": request}).data
计算百分比保留一位小数
data_dic[_] = (new_dic.get(_), '{:.1f}'.format(((new_dic.get(_)) / count) * 100) + '%')
weater_system_count_per = '{:.1f}%'.format((weater_system_count / total_count) * 100)
wind_system_count_per = '{:.1f}%'.format((wind_system_count / total_count) * 100)
数据库更新时间
sql1 = 'UPDATE bms_rule_faultwarning set create_time = ADDTIME (date("{0}") + interval 0 hour,time(create_time)),update_time = ADDTIME (date("{0}") + interval 0 hour,time(update_time))WHERE create_time like "{1}%"'.format('2019-02-13','2019-04-13')
更多精彩
