题记:要在数据库中查询当天信息的所有条数,获取当天的最小与最大时间搓进行条件筛选查询即可。
import datetime
import time
#获取当前时间搓
def get_timestamp():
cur_time = datetime.datetime.now()
a = datetime.datetime.strftime(cur_time, '%Y-%m-%d %H:%M:%S')
timeStamp = int(time.mktime(time.strptime(a, "%Y-%m-%d %H:%M:%S")))
return timeStamp
#解析时间搓
def jx_timestamp(timeStamp):
timeArray = time.localtime(timeStamp)
otherStyleTime = time.strftime("%Y-%m-%d %H:%M:%S", timeArray)
return otherStyleTime
timestr = jx_timestamp(get_timestamp()).split(" ")
dt1=timestr[0]+" "+"00:00:00"
dt2=timestr[0]+" "+"23:59:59"
timeArray1 = time.strptime(dt1, "%Y-%m-%d %H:%M:%S")
timeArray2 = time.strptime(dt2, "%Y-%m-%d %H:%M:%S")
timestamp1 = int(time.mktime(timeArray1))
timestamp2 = int(time.mktime(timeArray2))
print(timestamp1)
print(timestamp2)
print(jx_timestamp(timestamp1))
print(jx_timestamp(timestamp2))
输出图片: