本文共 1836 字，大约阅读时间需要 6 分钟。

第几周

# datetime.datetime.now().isocalendar()[1] int类型 queryset 返回的周次是从1开始，W = datetime.datetime.now().isocalendar()[1]# W = time.strftime("%W")  #  周次 从0开始 str类型LastWeek = time.strftime("%W")# 当前天 显示当前日期是本周第几天day_num = cur_time.isoweekday()# 计算当前日期所在周一monday = (cur_time - datetime.timedelta(days=day_num))# 查询一周内的数据all_datas = YourModel.objects.filter(time__range=(now_time, monday))#当前日期格式cur_date = datetime.datetime.now().date()#前一天日期yester_day = cur_date - datetime.timedelta(days=1)#前一周日期week = cur_date - datetime.timedelta(weeks=1)#查询前一周数据,也可以用range,我用的是glt,lte大于等于obj_list=Customer.objects.filter(deal_date__gte=week, deal_date__lte=cur_date)

gt：大于某个时间

now = datetime.datetime.now()#前一天start = now – datetime.timedelta(hours=23, minutes=59, seconds=59)a=yourobject.objects .filter(youdatetimcolumn__gt=start)

前几天

# 前15天 返回 2012-01-23diff_15_day = datetime.datetime.now().date() - datetime.timedelta(days=15)

今天

Customer.objects.filter(Date__range=(diff_15_day, diff_15_day))

gte：大于等于某个时间：

a=yourobject.objects .filter(youdatetimcolumn__gte=start)

lt：小于

a=yourobject.objects .filter(youdatetimcolumn__lt=start)

lte：小于等于

a=yourobject.objects .filter(youdatetimcolumn__lte=start)

range：查询时间段

start_date = datetime.date(2005, 1, 1)end_date = datetime.date(2005, 3, 31)Entry.objects.filter(pub_date__range=(start_date, end_date))

year：查询某年

Entry.objects.filter(pub_date__year=2005)

month：查询某月

Entry.objects.filter(pub_date__month=12)Customer.objects.filter(Date__year=time.strftime("%Y"), Date__month=time.strftime("%m")).count()

day：某天

Entry.objects.filter(pub_date__day=3)

week_day：星期几

Entry.objects.filter(pub_date__week_day=2)

获取今天的日期，日期格式为yyyy-MM-dd

from django.utils.timezone import now, timedeltadate = now().date() + timedelta(days=-1) #昨天date = now().date() + timedelta(days=0) #今天date = now().date() + timedelta(days=1) #明天

转载地址：http://ymvii.baihongyu.com/